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?
==========
