| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I sum depending on the background color of cells in Excel?
I would like to summarize numbers depending on the color i set in the
conditional formatting - meaning sum all REd cells, sum all Green Cell, ....etc |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I sum depending on the background color of cells in Excel?
If you are using conditional formatting to set those colours then you
can apply the same condition within a formula to add them up - a simple SUMIF, or SUMPRODUCT formula, depending on the complexity of the condition. Perhaps if you can give us the conditions that you are using ... ? Pete On Dec 14, 12:00 am, Erik MITON <Erik wrote: I would like to summarize numbers depending on the color i set in the conditional formatting - meaning sum all REd cells, sum all Green Cell, ....etc |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change background color in cells | Excel Worksheet Functions | |||
| Excel: Remove color background from cells, restore grid. | Excel Discussion (Misc queries) | |||
| Different background color depending on x-axis value | Charts and Charting in Excel | |||
| Color background with Matching cells in row | Excel Worksheet Functions | |||
| cell background color while searching through cells | Excel Discussion (Misc queries) | |||
Linear Mode
