SUMIF testing two columns...
 

HI,

I am tryng to use the SUMPRODUCT a following to sum ammount in column
"A" which take into account criteria in columns "B" and "C":


=SOMARPRODUTO((B2:B6=E2)+(C2:C6=F2);A2:A6)


Any Idea?


--
lgarcia
------------------------------------------------------------------------
lgarcia's Profile: http://www.excelforum.com/member.php...fo&userid=9520
View this thread: http://www.excelforum.com/showthread...hreadid=320461

=sumproduct((b2:b6=e2)*(c2:c6=f2)*(a2:a6))


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=320461