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?