SUMIFS when criteria is a comma separated list

[dha17]

Hi,

I am trying to perform a SUMIFS where one criteria is a comma separated list. It is a simple formula when the criteria is a single value (see C4 below), but how do I perform the SUMIF in C2 when the criteria is comma separated (A2)?

 

[Fluff]

Try

=SUM(SUMIFS(C8:C13,A8:A13,FILTERXML("<k><m>"&SUBSTITUTE(A2,", ","</m><m>")&"</m></k>","//m"),B8:B13,B2))

 

[dha17]

Try

=SUM(SUMIFS(C8:C13,A8:A13,FILTERXML("<k><m>"&SUBSTITUTE(A2,", ","</m><m>")&"</m></k>","//m"),B8:B13,B2))

Works perfectly. Thank you.

 

[Fluff]

You're welcome & thanks for the feedback.

 

[smozgur]

Works perfectly. Thank you.

@dha17 - in your future questions, please mark the post that answered your question instead of your feedback post as it will help future readers.
There is no further action necessary for this thread as I already switched the marked solution post.