Two Criteria in SumIf Function

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.

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

--
Don Guillett
SalesAid Software
[email protected]
"Jack Gillis" <[email protected]> wrote in message
news:[email protected]...
>
> 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)


"Jack Gillis" <[email protected]> wrote in message
news:[email protected]...
>
> 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.
>
>

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

"Jack Gillis" <[email protected]> wrote in message
news:[email protected]...
>
> 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.
>