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
--
Ta

MacII