two criteria sumif

  • Thread starter Thread starter Siegfried
  • Start date Start date
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
 
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
 
Back
Top