| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif with Conditionale formatting of a cell
I need to use sumif but only count the cells that are shaded blue. The blue
cells are subtotals that I don't want re-counted. Thank you, Chuck |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sumif with Conditionale formatting of a cell
If they are shaded by CF, include the CF condition in your SUMIF conditions.
If they are shaded by ordinary formatting, you'll need VBA to do the job. -- David Biddulph "Chuck" wrote in message ... I need to use sumif but only count the cells that are shaded blue. The blue cells are subtotals that I don't want re-counted. Thank you, Chuck |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using SUMIF function and conditional formatting | Excel Worksheet Functions | |||
| Conditional formatting w/ a sumif | Excel Discussion (Misc queries) | |||
| SUMIF + Conditional Formatting | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions | |||
Hybrid Mode
