Hello,

I have a table where I use Sumproduct to look up data in another table using the formula:

=SUMPRODUCT(($A$100:$A$140=$I9)*($99:$99=$G$2),$100:$140)

I9 is the ID code and G2 is a country.

This is fine but will not work if the relevant cell has text or symbols in it. Can anyone suggest an alternative formula?