Hi

Try
=SUMPRODUCT(--(B2:B1589="BCN"),--(C2:C1589="Yes"),E2:E1589)
assuming values in E2:E1589 are numeric.

--
Regards

Roger Govier


"jlhart76" wrote
in message ...

I'm trying to sum a group of numbers based on two variables. The SumIf
statement isn't working right, neither is SumProduct. Can someone
help?
Here's what the formula should calculate:

IF (B2:B1589="ICM") and IF (C2:C1589="Yes"), then SUM (E2:E1589)


--
jlhart76
------------------------------------------------------------------------
jlhart76's Profile:
http://www.excelforum.com/member.php...o&userid=30274
View this thread:
http://www.excelforum.com/showthread...hreadid=499413