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