That would be a problem but if they could enter it in (in this example) 3
cells across

=SUM(($A$2:$A$10=J1:L1)*(B2:B10))

or using 3 cells in the same column

=SUM(($A$2:$A$10=TRANSPOSE(F1:F3))*(B2:B10))

both formulas needs to be entered with ctrl + shift & enter

or maybe easier if you use the same number of accounts

=SUM(($A$2:$A$10=TRANSPOSE(F1:F10))*(B2:B10))

then you can just type in the accounts in F1:F10




--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




wrote in message
oups.com...
Thats for the quick reponse... its exactly what I needed.

I might be asking too much but what about making it a bit more user
friendly by putting the critera in a seperate cell
=SUMPRODUCT(($A$2:$A$10=criteracell*(B2:B10))

where somebody could enter something like 1,3,4 into the criteracell

Otherwise I will just use search and replace when I want to change the
critera in all the formulas I create.

Thanks again
Gary