If you are always add what is in column F
=SUMPRODUCT((B47:B52=LEFT(E3,3))+((B47:B52=RIGHT(E 3,3))*LEN(E3)=7),F47:F52)

If you want to control the column F is column 6)
=SUMPRODUCT(((B47:B52=LEFT(E3,3))+((B47:B52=RIGHT( E3,3))*LEN(E3)=7))*(COLUMN(C47:K52)=6)*C47:K52)

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"shapper" wrote in message
...
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