| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
SUMIF on Fill color
Is it possible to use SUMIF or similar to sum cells where the Fill Color is
Yellow for instance ?? IE something along the lines of =SUMIF(C3:C15),"FillColor=Yellow",C3:C15) ...... At present I'm getting along by adding a separate column which has an asterisk in it and using that as the basis for the SUMIF, but I'd rather just change the cell colour to select the amounts I'm interested in. Thanks Dave H. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill Effects on Fill Color | Excel Discussion (Misc queries) | |||
| My fill color and font color do not work in Excel Std Edition 2003 | Excel Discussion (Misc queries) | |||
| Fill Color Red | Excel Discussion (Misc queries) | |||
| Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
| A different "Fill Color" problem | Excel Worksheet Functions | |||
Threaded Mode
