| 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 |
| 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 | |||
Threaded Mode
