| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum Formula to Exclude Certain Cell Values/Backgrounds
Incell range W15:W31, percent values are font/background-color conditional
formatted. In cell W10 is the following formula: =SUM(X15:X31) What would the formula be to exclude in the sum, a cell having a green background and a zero percent value? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need this formula to exclude cell value 'x' and 'xx' when counting | Excel Discussion (Misc queries) | |||
| Exclude #N/A values and Return Numeric values to consecutive cells in Single Row | Excel Worksheet Functions | |||
| charts exclude cell with formula | Charts and Charting in Excel | |||
| funtions for colors for fonts or cell backgrounds? | Excel Worksheet Functions | |||
| Excel 2003 - SUM Formula - exclude cell | Excel Worksheet Functions | |||
![Phil Hageman[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
