SUMIF Problem

**robertguy** · 10-12-2007, 05:56 AM

Hi,

I am currently using the formula =SUMIF($B$4:$B$20,"XP Project",H$4:H$20) which adds up all the totals in column 'H' (H4:H20) which are flagged "XP Project in Column 'B' (B4:B20).

What I would like to do is to add another criteria to this formula so it would also look in Column A for a name i.e. Bob Guy so the result would be :-

Sum totals in 'H' (H4:H20) where "XP Project" is flagged in Column 'B' (B4:B20) and "Bob Guy" is flagged in Column 'A' (A4:A20)

I would be most grateful for any assistance of the correct syntax of this formula

Many thanks in advance

Bob - Excel version 2003

**daddylonglegs** · 10-12-2007, 06:01 AM

If you're not using Excel 2007 then SUMPRODUCT is your best bet for multi-conditional counting or summing i.e.

=SUMPRODUCT(--($B$4:$B$20="XP Project"),--($A$4:$A$20="Bob Guy"),H$4:H$20)