two criteria sumif

S

Siegfried

I have a database and i'm trying to get a sum based on a
2 column criteria. like a =sumif(... except based on
meeting two columns. I can't figure out the syntax for
the =sumif(and(... but that may not be right anyway. Is
there a way to do this?

Siegfried
 
B

Bernard Liengme

Hi Siegfried,
Try this =SUMPRODUCT(--(A1:A10="X"),--(B1:B10>3),C1:C10
This sums the C cells when the corresponding A cell =X and the corresponding
B cell is greater that 3
The double negation serves to coerce FALSE/TRUE into 0/1
Best wishes
 

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

Multiple Columns in Sum Range using SUMIFS 1
SUMIF with criteria "<>" & "=" 4
Use TODAY() function as the criteria in a SUMIF formula 1
Result based on two criteria 3
Help with SUMIFS 2
SumIf equation question 6
SUMIFS, one criteria range, multiple criteria 2
sumif issues 1

Top