sumnumbers based on two criterias

[Jimmy Joseph]

Hello,

Need your help to sum a range of numbers based on two criterias.

eg.

A1 to A4 contains number 5,5,6,7
BI to B4 contains text A,B,C,B
C1 to C4 contains text I,II,II,II

I wanted to sum cells in column A, where B:B = C and C:C = II (in this
result =12)

For one criteria i could do it with Sumif function.

Please help!


Jimmy Joseph

[Bob Umlas]

=SUMPRODUCT(--(B1:B4="C"),--(C1:C4="II"),A1:A4)
Bob Umlas
Excel MVP

"Jimmy Joseph" <jimmy.joseph@in.bosch.com> wrote in message
news:Xns974F63E725A21jimmyjosephinboschco@client.loc.cc.bosch.com...
> Hello,
>
> Need your help to sum a range of numbers based on two criterias.
>
> eg.
>
> A1 to A4 contains number 5,5,6,7
> BI to B4 contains text A,B,C,B
> C1 to C4 contains text I,II,II,II
>
> I wanted to sum cells in column A, where B:B = C and C:C = II (in this
> result =12)
>
> For one criteria i could do it with Sumif function.
>
> Please help!
>
>
> Jimmy Joseph