Sum function
 

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

Sum function
 

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


"MacII" wrote:

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

Sum function
 

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)

"MacII" wrote in message
...
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