MrExcel Publishing
Your One Stop for Excel Tips & Solutions

SUMIF


Posted by Chris on February 01, 2002 9:15 AM

I need to sum a range of cells based on two different ranges with two separate criteria. I am thinking that it is an array formula, but I don't quite know how to put them together yet.

(i.e. a1:a10 = 5 and d1:d10 = 40 then sum corresponding cells B1:b10)

Thanks in advance!!

Chris


Posted by Aladin Akyurek on February 01, 2002 9:33 AM


Try:

=SUMPRODUCT((A1:A10=5)*(D1:D10=40),B1:B10)

Aladin

============

Posted by Chris on February 01, 2002 12:08 PM

Chris

Posted by Aladin Akyurek on February 01, 2002 1:04 PM

What do you get when you enter the formula?

==========