SUMIFS Workaround For Multi-Select Dropdowns - Google Sheets

Standard sumif/sumifs does not work with multi-select dropdowns (for the selection OR the data) in Google Sheets, so check out this workaround that allows you to sum up multi-select data, including using an OR match (any of the selections), or an AND match (all of the selections) tied to a multi-select dropdown.
You can make a copy of the Google Sheets template here: bit.ly/3NP6ArE
You can check out the filtering multi-select data video here: • How to Filter Multi-Se...
A formula for counting multi-select data here: • Multi-Select Dropdowns...

[@shubhamsutar2]

This is not working for me as the Column contains Multiple Chips of Numbers and no texts. Can you provide solution to this?

[@SheetsNinja]

Can you provide a sample of what you're trying to do with this? Maybe a copy of the Google Sheet with just that section? I just want to see what you're doing to see if there is an easy solution or adjustment.

[@shubhamsutar2]

@SheetsNinja Heyy! Thank you for your response. I am glad to say that I have got the solution. =IFERROR(SUM(FILTER(J:J, ISNUMBER(VALUE(E:E)) * REGEXMATCH(TEXT(E:E, "0"), TEXTJOIN("|", TRUE, "\b" & SPLIT(A52, ", ") & "\b")))))