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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying formulas across columns 2
Can I use sumif with OR to sum based on two column criteria? 1
Consolidation if a least one criteria is met 4
sumproduct with multiple variables 8
Sumif Question 1
Conditional sum, when condition has multiple values 3
Adding 2 Values When 3 Conditions are Met, Including an "OR" 8
Multiple Criterion in a SUMIF function 6

Top