I am trying to use a sumif with multiple criteria so that it will sum with a
range of data included in the criteria. The criteria will be 50+ cells in a
row.

=SUMIF($B$3:$B$6,B10:D10,$C$3:$C$6)

I'm not sure how to get this to work or if I need to use a sumproduct
formula instead?

Try it like this:

=SUMPRODUCT(--(ISNUMBER(MATCH(B3:B6,B10:D10,0))),C3:C6)

--
Biff
Microsoft Excel MVP


"No Idea" <No wrote in message
...
I am trying to use a sumif with multiple criteria so that it will sum with
a
range of data included in the criteria. The criteria will be 50+ cells in
a
row.

=SUMIF($B$3:$B$6,B10:D10,$C$3:$C$6)

I'm not sure how to get this to work or if I need to use a sumproduct
formula instead?

Thank-you so much!

"T. Valko" wrote:

Try it like this:

=SUMPRODUCT(--(ISNUMBER(MATCH(B3:B6,B10:D10,0))),C3:C6)

--
Biff
Microsoft Excel MVP


"No Idea" <No wrote in message
...
I am trying to use a sumif with multiple criteria so that it will sum with
a
range of data included in the criteria. The criteria will be 50+ cells in
a
row.

=SUMIF($B$3:$B$6,B10:D10,$C$3:$C$6)

I'm not sure how to get this to work or if I need to use a sumproduct
formula instead?

You're welcome!

--
Biff
Microsoft Excel MVP


"No Idea" wrote in message
...
Thank-you so much!

"T. Valko" wrote:

Try it like this:

=SUMPRODUCT(--(ISNUMBER(MATCH(B3:B6,B10:D10,0))),C3:C6)

--
Biff
Microsoft Excel MVP


"No Idea" <No wrote in message
...
I am trying to use a sumif with multiple criteria so that it will sum
with
a
range of data included in the criteria. The criteria will be 50+ cells
in
a
row.

=SUMIF($B$3:$B$6,B10:D10,$C$3:$C$6)

I'm not sure how to get this to work or if I need to use a sumproduct
formula instead?