Add selected numbers in a column that are a different color

[Sam]

I have a column of numbers. Some are black, some are red. I cannot sort the
red numbers to a specific section. Is there a way of adding just the red
numbers? I was thinking of placing my cursor in an adjacent column (say
column D) and using some sort of of IF formula like: IF C3= red fonted
number, then place it here, otherwise leave blank.

Anyone with any ideas? Thanks to anyone who takes the time to respond!

Sam

 

[Bob Phillips]

Take a look at the solution at
http://www.xldynamic.com/source/xld.ColourCounter.html

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Sam]

Very cool, Bob. But I get a #NAME? error. I am using the the second
SUMPRODUCT formula under the Summing Coloured Cells section of the link you
provided. BTW, in that formula does the number 3 refer to code number of the
color red?

Thanks for all your help so far. This is really interesting.

Sam

 

[Sam]

When I use the =ColorIndex(f3) to determine the colorindex code of what I am
thinking is a red font color, I also get a #NAME? error. Any thoughts?

BTW, Excel is saying my font color is RED.

Sam

 

[Sam]

BTW, I am using Excel 2003, Service Pack 1.

Take a look at the solution at
http://www.xldynamic.com/source/xld.ColourCounter.html

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Gord Dibben]

Sam

How did the numbers' font get colored red? Manually or through Conditional
Formatting?

If by CF, sum on that criteria.

If manually, Excel has no built-in Function for that.

You will need a User Defined Function.

Chip Pearson has one.

http://www.cpearson.com/excel/colors.htm

Look for CellColorIndex UDF and read Chip's instructions on usage.


Gord Dibben Excel MVP

 

[Bob Phillips]

Where did you store the ColorIndex function? You did save it in your
workbook I presume?

--

HTH

RP
(remove nothere from the email address if mailing direct)