SUMIF testing two columns...

L

lgarcia

HI,

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


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


Any Idea
 
Top