| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I Sum by Cell Colour or Format?
I have a large list of values, these values have been colour coded. I would
like to sum each of the colours seperately. I know i can add a filter, sort by colour & sum this for each coulour, but am wondering if there is a formula that would do this for me? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I Sum by Cell Colour or Format?
Ashley,
have a look here http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Ashley" wrote: I have a large list of values, these values have been colour coded. I would like to sum each of the colours seperately. I know i can add a filter, sort by colour & sum this for each coulour, but am wondering if there is a formula that would do this for me? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditionl format a cell to change text colour | Excel Discussion (Misc queries) | |||
| Can i format (colour) selective text in a cell using excel2000? | Excel Discussion (Misc queries) | |||
| Format Cell Colour | Excel Worksheet Functions | |||
| Format Cell Colour | Excel Worksheet Functions | |||
| Format Cell Colour | Excel Worksheet Functions | |||
Linear Mode
