| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM of conditional formatting cells
I have a worksheet that has cells that have conditional formatting
attached to them. What I need to do is to get the sum of cells with specific colour backgrounds. Is there a formula that will do that? Esradekan |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUM of conditional formatting cells
If your CF condition is fairly simple (like cell contents greater than
100), then you could use SUMIF. With more complex conditions you may have to use SUMPRODUCT. In either case you need to set up the same conditions as are used in your conditional formatting. Hope this helps. Pete On Oct 10, 12:59*am, Esradekan wrote: I have a worksheet that has cells that have conditional formatting attached to them. *What I need to do is to get the sum of cells with specific colour backgrounds. *Is there a formula that will do that? Esradekan |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUM of conditional formatting cells
Yep, that will do it, thanks so much.
Esradekan On Oct 10, 1:09*pm, Pete_UK wrote: If your CF condition is fairly simple (like cell contents greater than 100), then you could use SUMIF. With more complex conditions you may have to use SUMPRODUCT. In either case you need to set up the same conditions as are used in your conditional formatting. Hope this helps. Pete On Oct 10, 12:59*am, Esradekan wrote: I have a worksheet that has cells that have conditional formatting attached to them. *What I need to do is to get the sum of cells with specific colour backgrounds. *Is there a formula that will do that? Esradekan- Hide quoted text - - Show quoted text - |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUM of conditional formatting cells
You're welcome.
Pete On Oct 10, 2:24*am, Esradekan wrote: Yep, that will do it, thanks so much. Esradekan On Oct 10, 1:09*pm, Pete_UK wrote: If your CF condition is fairly simple (like cell contents greater than 100), then you could use SUMIF. With more complex conditions you may have to use SUMPRODUCT. In either case you need to set up the same conditions as are used in your conditional formatting. Hope this helps. Pete On Oct 10, 12:59*am, Esradekan wrote: I have a worksheet that has cells that have conditional formatting attached to them. *What I need to do is to get the sum of cells with specific colour backgrounds. *Is there a formula that will do that? Esradekan- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting and sum of cells | Excel Discussion (Misc queries) | |||
| Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
| conditional formatting of cells | Excel Worksheet Functions | |||
| Conditional Formatting with two cells | Excel Worksheet Functions | |||
| Conditional Formatting Multiple cells based on 2 cells | Excel Worksheet Functions | |||
Linear Mode
