How to next condition to do Sumif

**pph2113** · 03-15-2013, 02:07 PM

Hi,

I want to sum only those values in column "I" when 1) the corresponding value in column A is "West" and 2) value in column F is blank. Range is Row 2 to 500. I tried the following formula but it doesn't work. Can somebody please help? Tkx!

=SUMIF(A2:F500, AND(A2:A500="West", ifblank(F2:F500), I2:I500))

**bentleybob** · 03-15-2013, 02:14 PM

Please Login or Register  to view this content.

**Richard Buttrey** · 03-15-2013, 02:16 PM

Hi,

For multiple conditions, if you have XL 2007 or later then you'l need a SUMIFS (plural)

=SUMIFS(I2:I500,A2:A500,"West",F2:F500,"<>")

otherwise a SUMPRODUCT

=SUMPRODUCT((I2:I500)*(A2:A500="West")*(F2:F500<>""))