Not sure if this is what you're looking for or not, or if you need to have
everything in one cell, per se.

On List sheet, in B2, enter:

=sumif(Data!A$2:A$2000,B2,Data!B$2:B$2000)

Fill this down to B10. Then, in B11, enter

=sum(Data!B2:B2000)-sum(A2:A10)

That will back into the number you want, by totalling the whole thing and
then removing the amounts that correspond to the listed names. Not nearly as
elegant as what you're describing, but ought to give the right result if it
fits into space constraints.

Good luck.
--
Mike Lee
McKinney,TX USA


"~L" wrote:

By itself, it returned 1 (The match with 'other' was NA).
When added in to the expanded formula:
=SUMPRODUCT(--(Data!$B$2:$B$2000)*--(ISNA(MATCH(List!$A$2:$A$10,Data!$A$2:$A$2000,0))) )
It returned NA because A2:A10 is not the same size as the other arrays.
When A2:A10 is expanded, the formula returns a number that is higher than the
expected result (the check for this was to sum the totals on the list page,
then sum the values on the data page, since it is hopefully sorting out
numbers by names, the results should be equal but were not).