Add selected numbers in a column that are a different color
 

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

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

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

"Bob Phillips" wrote:

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

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

"Bob Phillips" wrote:

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

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

"Bob Phillips" wrote:

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

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

On Fri, 4 Mar 2005 13:29:03 -0800, Sam wrote:

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

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)


"Sam" wrote in message
...
BTW, I am using Excel 2003, Service Pack 1.

"Bob Phillips" wrote:

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