Search : in
By :

Please help with excel formula

Last answer on Jun 28, 2009 11:07:35 am BST Dollster, on Jun 28, 2009 12:57:30 am BST 
 Report this message to moderators

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.

Configuration: Windows Vista
Firefox 3.0.11

Best answers for « Please help with excel formula » in :
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
[VBA] A function that returns the color of an active MFC Show[VBA] A function that returns the color of an active MFC This function returns the value of the active format in conditional formatting. With the function below, two values can be returned. Mode = 0: the value of Interior.ColorIndex...
Adding data from one column using another ShowAdding data from one column using another Issue Solution Note Issue I am having a real problem with an Excel formula. I have a worksheet with variable rows and a number of columns. I need to add together the values of particular...
Ask your question Reply

venkat1926, on Jun 28, 2009 1:58:51 am BST

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?

   
Reply to venkat1926

2

Dollster, on Jun 28, 2009 2:32:31 am BST

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.

   
Reply to Dollster

3

 venkat1926, on Jun 28, 2009 11:07:35 am BST

Where did you write this formula

   
Reply to venkat1926
Ask your question Reply
They need your help