=SUMIF(C:C,J5,E:E)+SUMIF(C:C,J5,f:f)



"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)


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