|
View unanswered posts | View active topics
It is currently Sat May 17, 2025 10:41 am
|
Page 1 of 1
|
[ 4 posts ] |
|
| 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)
|
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.
|
| 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
|
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
|
| 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)
|
Thanks, I'll give it a try.
|
| 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)
|
That works perfectly. Thanks for the help.
|
| Tue Apr 17, 2012 1:49 am |
|
|
|
|
Page 1 of 1
|
[ 4 posts ] |
|
Who is online |
Users browsing this forum: No registered users and 2 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
|
|
