How to sum SUMIFS - multiple criteria for one criteria range???

1. How to sum SUMIFS - multiple criteria for one criteria range???

I'm trying to find a better way to sum multiple criteria for the same criteria range instead of adding another SUMIFS for every criteria cell. Check out my formulas in Row 77 - Holy Cow! Yes, they work, but I know there's a way to use the entire range of criteria in Col. E (Table worksheet)...

Can someone please point me in the right direction? I don't need explicit instructions, just need to spend time on something that I know can work...

2. Re: How to sum SUMIFS - multiple criteria for one criteria range???

Try
=SUMPRODUCT(SUMIFS(Table!\$C\$3:\$C\$66,B\$3:B\$66,Table!\$E\$17:\$E\$23))

And FYI, this is just a little nitpicky I guess.
But it's only 1 criteriarange, so you can use sumif instead of sumifS
=SUMPRODUCT(SUMIF(B\$3:B\$66,Table!\$E\$17:\$E\$23,Table!\$C\$3:\$C\$66))

3. Re: How to sum SUMIFS - multiple criteria for one criteria range???

although I don't follow the results, I think it can easier be done with a pivot table.

see the attached file.

4. Re: How to sum SUMIFS - multiple criteria for one criteria range???

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1