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)?
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)?