| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum up a column ignoring values coloured red
Hi,
Am Mon, 15 Dec 2014 19:25:51 +0000 schrieb Quilp: 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? you could use Filter by color = No fill and then =Subtotal(9,A1:A20) Modify range to suit. Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
| 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
