Sum function

[Guest]

I have excell 2000. I have a column of numbers, some formatted red, and some
formatted green. I do not want to split the fiures/numbers, as they may
change in value/colour format.

I want to sum the red figures and sum the green figures at the end of the
column. I cannot find a formula that will work.

Any suggestions anyone ?. Please !. Getting desperate, and frustrated

 

[Guest]

http://www.cpearson.com/excel/colors.htm
Chip shows you how to build your own function to do this.

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)