Sumif with Multiple Criteria

[No Idea]

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,B1010,$C$3:$C$6)

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

 

[T. Valko]

Try it like this:

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

 

[No Idea]

Thank-you so much!

Try it like this:

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

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Thank-you so much!