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