Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to add numbers in a column dependant on their colour
I have a spreadsheet with numbers in 2 different colours in each column. Is
there a formula I can use to total only numbers in one colour? |
#2
|
|||
|
|||
See http://www.xldynamic.com/source/xld.ColourCounter.html, but note the
constraints -- HTH Bob Phillips "24 Jan 05" wrote in message ... I have a spreadsheet with numbers in 2 different colours in each column. Is there a formula I can use to total only numbers in one colour? |
#3
|
|||
|
|||
it depends on how thee colors are applied.
If the colors are from conditional or custom formating. the same criteria for the formating can be used in a sumproduct() or similar formula. If the colors were changed by hand, a macro will be needed. something like the one in http://www.cpearson.com/excel/colors.htm "24 Jan 05" wrote: I have a spreadsheet with numbers in 2 different colours in each column. Is there a formula I can use to total only numbers in one colour? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consecutive Numbers down a column not to Exceed 49 | Excel Worksheet Functions | |||
column filtering to match identical numbers | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Average of numbers in column between to other numbers | Excel Discussion (Misc queries) | |||
Add selected numbers in a column that are a different color | Excel Discussion (Misc queries) |