Sumif with Multiple Criteria

N

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,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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top