| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
sum up a column ignoring values coloured red
I have a column of monetary values for which I need to find the sum total but excluding the rows where the value is coloured red. If this is not possible, can I enter the values, that I wish to ignore, in some other way e.g bold, italic etc?
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate average from non contiguous column, ignoring (0) values | Excel Worksheet Functions | |||
| adding values in coloured cells | Excel Discussion (Misc queries) | |||
| average values in non-contiguous cells, ignoring 0 values | Excel Worksheet Functions | |||
| Ignoring Negative Values | Excel Discussion (Misc queries) | |||
| a macro to count coloured values and copy.... | Excel Programming | |||
Threaded Mode
