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...
Thanks for any advice!
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))
although I don't follow the results, I think it can easier be done with a pivot table.
see the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
with a revisted pivot table.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks