SUMPRODUCT help please

[sjm]

Hi, I have a column of names and a column of values against the names (the names appear multiple times in the list). I have used SUMPRODUCT to add up all the values for some of the names but there is a large quantity of miscellaneous names that I want to add together. Can I use SUMPRODUCT to say 'add up all the values for the names that do not equal the names I have added up already'?

I hope I am making sense, if anyone can give me any tips I would be grateful!

[pinmaster]

Hi

=SUMPRODUCT((A1:A10<>"Bob")*(A1:A10<>"Joe"),B1:B10)


HTH
Jean-Guy

[sjm]

Thanks very much. Is there any way this can be done on a range of cells? I have about 35 names I want to exclude.

[daddylonglegs]

If your names are in A1:A100, values in B1:B100, 35 names to exclude in C1:C35

=SUMPRODUCT(--ISNA(MATCH(A1:A100,C1:C35,0)),B1:B100)

[sjm]

Thanks, I'll give it a go!