sumif with 2 criteria
 

I am trying to sum a column that needs to meet 2 criteria and am not sure how
to create it - any help would be GREAT!!

Hi Jamie

use the SUMPRODUCT function
=SUMPRODUCT(--(Range1=Criteria1),--(Range2=Criteria2),RangetoSum)
e.g.
=SUMPRODUCT(--(A1:A100="Big"),--(B2:B100="Blue"),C1:C100)

check out
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

for more details on how this function works.

Cheers
JulieD

"Jamie" wrote in message
...
I am trying to sum a column that needs to meet 2 criteria and am not sure
how
to create it - any help would be GREAT!!

Hi
use SUMPRODUCT. See:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
Regards
Frank Kabel
Frankfurt, Germany

"Jamie" schrieb im Newsbeitrag
...
I am trying to sum a column that needs to meet 2 criteria and am not
sure how
to create it - any help would be GREAT!!