Hi,

I have a list of names and a list of names with a list of values and I'm
using Sumproduct to compare the two and give the sum of the values for each
name.

But one of the names on the comparison list is 'other' which is meant to
include all names not on the list.

When I add *--(Data!A2:A2000<List!A2:A10) it doesn't work because the
arrays aer not the same size. If I make them the same size, or if I list out
the names as in *--(Data!A2:A2000<{"Name1","Name2","Name3"}) the expected
value is not returned.

It seems I'm not asking Excel for what I think I'm it asking for.

How do I get the sum of the values for all names not on my list?