Previous Topic Next Topic

Please help with excel formula

Closed
Dollster - Jun 27, 2009 at 07:57 PM
venkat1926 Posts 1863 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.
Related:

2 responses

Answer 1 / 2
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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?
Dollster
Jun 27, 2009 at 09:32 PM
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.
Answer 2 / 2
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jun 28, 2009 at 06:07 AM
where did you write this formula

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response