Adding formula help (1 Viewer)

[Tansar]

Hi,
I am trying to calculate a total of a column based on a criteria.

I have in column B either "Y" or "No".
I have in Column C a figure

Column D (at the bottom) I have the total for Y AND the next row of totals for N.

I'm kinda stuck. Do I use the If formula or the Vlookup or even combined, may be someother formula. Just not getting it right at the moment, lol.

Hope someone can help' appreciated.

 

[PaulJR]

How about using a pivot table? You could create a pivot table, and insert your column B header as the column field and the totals as the data item. This will give you the totals for both Y and N.
------------------------------------------------------------
Otherwise, if could paste this formula in column D row 2, assuming your data starts in row 2, and paste it down to the end of your data, it will give you values where a Y exists.

=if(B2="Y",C2,"")

Then at the bottom of column D, you could use the SUM formula to calculate the total for Y. To calculate N, just subtract Y from the total of both Y and N. Does that make sense?

 

[qafself]

Use SUMIF - Excel help will explain the detail