• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help with SUMIFS using multiple criteria in multiple columns

indimonk

New Member
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
 

Attachments

Juniad

Member
=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

Excel Ninja
indimonk
Would You reread:
and Please Don't ... twice, please.
 
Top