hi
there are 10 different function on that page not counting "other function".
please post the one you are using.

Regards
FSt1

"april" wrote:

i have copied the code from cpearson.com/excel/colors.htm which allows you to
sum a range of cells by color. this worked fine in one spreadsheet but when
i copied the same code to another spreadsheet i get a NAME? error. any
suggestions?

thank you
--
aprilshowers