Help with SUMIFS using multiple criteria in multiple columns

[indimonk]

Hello,
Hello,

I have to make a summary sheet based on various input factors.

Please refer the attachment for a gist of my input and output requirements.

I will need SUMIFS using multiple criteria in multiple columns.

Or if there is a better way to pull this off, please let me know.

Presently, I apply filters for each column based on the condition and take the SUBTOTAL value from SALES.

Is it possible to replicate the same with some functions?

Thanks in advance

 

[AliGW]

Cross-posted: https://www.excelforum.com/excel-fo...ng-multiple-criteria-in-multiple-columns.html

 

[Juniad]

=SUMPRODUCT((($F$5:$F$13=LEFT(G18,SEARCH(" ",G18)-1))+($F$5:$F$13=RIGHT(G18,LEN(G18)-SEARCH(" ",G18,SEARCH(" ",G18)+1))))*(($E$5:$E$13=IF(LEN(F18)>4,LEFT(F18,SEARCH(" ",F18)-1),F18))+($E$5:$E$13=IFERROR(RIGHT(F18,LEN(F18)-SEARCH(" ",F18,SEARCH(" ",F18)+1)),0)))*($D$5:$D$13=E18),$G$5:$G$13)

Copy this formula to H18 and fill down.

 

[vletm]

indimonk
Would You reread:

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

and Please Don't ... twice, please.