• 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

  • Sum Multiple Criteria.xlsx
    9.6 KB · Views: 4
=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.
 
indimonk
Would You reread:
and Please Don't ... twice, please.
 
Back
Top