Hello,

On the cell H3 I have teh following:
=IF(ISNA(INDEX(B$47:K$52;MATCH($E3;B$47:B$52;0);5) ); 0; INDEX(B$47:K
$52;MATCH($E3;B$47:B$52;0);5))

Basically, it looks for a match of E3 value in range B$47:B$52 and
gets the value the 5th column.

At the moment a possible value of E3 is "COM".
And there is only one "COM" value in the range list.

What I would like is in E3 to be able to have "COM" or "COM,NET".

When there are two values in E3 I would get the SUM of the values of
the 5th column in the range that match the values COM and NET.

How can I change my code to do this?

Thanks,
Miguel