Please help with excel formula

Closed
Dollster - Jun 27, 2009 at 07:57 PM
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
- Jun 28, 2009 at 06:07 AM
Hello,
I am trying to write what I think is a simple formula but I can't get it. I am trying to count up guests for a bbq. I want to say if cell c3 to c44 has a Y then add the number in the cell and if cell c3 to c 44 has an N then subtract that number.

2 replies

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
805
Jun 27, 2009 at 08:58 PM
you query not clear. what do you want to do;. do you want to find out how many people are coming for bbq. Then you have to add only the Ys. If this assumption is correct try this formula

=countif(C3:C44,"y")

does this help you?
0
yes, that's what I want exactly, unfortunately it didn't work. It made mention of circular reference or something but then it disappeared and now nothing comes up at all.
0
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
805
Jun 28, 2009 at 06:07 AM
where did you write this formula
0