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.
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.