x404.co.uk - View topic

View unanswered posts | View active topics It is currently Wed Jun 04, 2025 2:45 pm

Excel help

Moderators: saspro, HeatherKay, belchingmatt, timark_uk, Blue_Nowhere, l3v1ck, veato

Page 1 of 1

[ 4 posts ]

Print view

Previous topic | Next topic

Excel help

Author

Message

l3v1ck

What's a life?

Joined: Fri Apr 24, 2009 10:21 am
Posts: 12700
Location: The Right Side of the Pennines (metaphorically & geographically)

Excel help

Can anyone offer any advice on the formula I need to use to do this:

I want a formula that says "If the sum of cells T22:T27 is 6, then 1, if not then 0
". I can't find any way of doing that without creating and extra row with the total of T22:T27, then saying "is the number in T28 6?"
I really don't want to do that if at all possible.

If that's not possible, is there a way of saying "If the letter in cell D28 is Y, then 1, if not then 0".

Thanks in advance.

_________________


	pcernie wrote: 'I'm going to snort this off your arse - for the benefit of government statistics, of course.'

Tue Apr 17, 2012 1:15 am

Fogmeister

I haven't seen my friends in so long

Joined: Thu Apr 23, 2009 7:35 pm
Posts: 6580
Location: Getting there

Excel help

Should be able to do...

=if(sum(t22:t27)=6,1,0)

That should work.

HTH

---
I am here: http://tapatalk.com/map.php?m1z3pl

_________________
Oliver Foggin - iPhone Dev


	JJW009 wrote: The count will go up until they stop counting. That's the way counting works.

Doodle Sub!
Game Of Life

Tue Apr 17, 2012 1:36 am

l3v1ck

What's a life?

Joined: Fri Apr 24, 2009 10:21 am
Posts: 12700
Location: The Right Side of the Pennines (metaphorically & geographically)

Re: Excel help

Thanks, I'll give it a try.

_________________


	pcernie wrote: 'I'm going to snort this off your arse - for the benefit of government statistics, of course.'

Tue Apr 17, 2012 1:47 am

l3v1ck

What's a life?

Joined: Fri Apr 24, 2009 10:21 am
Posts: 12700
Location: The Right Side of the Pennines (metaphorically & geographically)

Re: Excel help

That works perfectly. Thanks for the help.

_________________


	pcernie wrote: 'I'm going to snort this off your arse - for the benefit of government statistics, of course.'

Tue Apr 17, 2012 1:49 am

Page 1 of 1

[ 4 posts ]

Who is online

Users browsing this forum: No registered users and 50 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum