| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 |
|
#6
|
|||
|
|||
|
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 |
|
#7
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| no row numbers or column letters DISPLAYED | Excel Discussion (Misc queries) | |||
| need to find which numbers (3+) in a column sum to a value | Excel Discussion (Misc queries) | |||
| I cannot get a column of numbers to sum, why? | Excel Discussion (Misc queries) | |||
| I cannot get a column of numbers to sum, why? | Excel Worksheet Functions | |||
| Cannot get a column of numbers to SUM...why? | Excel Worksheet Functions | |||
Linear Mode
