Try...

=SUMPRODUCT((C1:C100=J5)*E1:F100)

Note that SUMPRODUCT does not accept whole column references.

Hope this helps!

psmith4497 Wrote:
is doing a SUMIF over multiple columns not allowed?

This formula works =SUMIF(C:C,J5,E:E)
but this does not: =SUMIF(C:C,J5,E:F)


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=380121