Please help with excel formula

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
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?
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.
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
where did you write this formula