Find total of one column controlled by another column

Hi,

I'm still new to this and was helped a lot by my first query on this Forum.

I now want to find the total money of one column (say column E) but only want it to count total for the times a particular word (say "Bag") appears in another column (say column B).

Would I use the SUMIF command, something along the lines of . . .

=SUMIF(E7:E202)+IF(B7:B202,"Bag",TRUE)

I understand that this is not correct, because it does not work, but maybe you can see what I am trying to achieve.

Regards

Brian

You need to check out the syntax of the SUMIF function.

I think you are trying to do this:

=SUMIF(B7:B202,"Bag",E7:E202)

Note that the first range is the range for comparison, and the second range is the range to sum if the condition is met.

There is a similar function, SUMIFS, which allows you to use more than one criteria, but that has a different syntax, i.e.:

=SUMIFS(sum_range,criteria_range_1,criteria_1,criteria_range_2,criteria_2, ... and so on with pairs of criterion_range and criterion ... )

Hope this helps.

Pete

Thank you for your help.

Regards

Brian