Two Criteria in SumIf Function

  • Thread starter Thread starter Jack Gillis
  • Start date Start date
J

Jack Gillis

I would like to use Excel's SUMIF function to get the sum of a field in a
database using TWO criteria. That is for example, get the sum of field A if
the data in field B is one value and the data in field C is another so that
I have the sum of A's when B and C meet their criteria.

I do it now with a pivot table but would like to eliminate the table.

Is this possible?

Thank you very much.
 
=SUMPRODUCT(--(B1:B200="text"),--(C1:C200=number),A1:A200)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Back
Top