Two Criteria in SumIf Function

[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.

 

[Don Guillett]

try
=sumproduct((rngb=1)*(rngc="b")*rnga)

 

[Bob Phillips]

=SUMPRODUCT(--(B1:B200="text"),--(C1:C200=number),A1:A200)

--

HTH

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

 

[Jack Gillis]

Thank you Bob and Don. I will give that a try.