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. |
#2
|
|||
|
|||
See http://www.xldynamic.com/source/xld.ColourCounter.html
-- HTH Bob Phillips "Dave H hotmail com" <flameboy4<atdot wrote in message ... 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. |
#3
|
|||
|
|||
"Bob Phillips" wrote in message
... See http://www.xldynamic.com/source/xld.ColourCounter.html -- HTH Bob Phillips Thanks Bob, Works like a charm - any idea on making it update dynamically on change of cell colour ? As it stands I have to activate the cell with the formula and click in the formula bar to make it update. Tried F9 but no luck. Cheers Dave. |
#4
|
|||
|
|||
It cannot be fully dynamic Dave as the cell colour change does not trigger
the recalc. You can make it respond to F9 by adding Application.Volatile at the start of the Colorindex function. -- HTH Bob Phillips "Dave H hotmail com" <flameboy4<atdot wrote in message ... "Bob Phillips" wrote in message ... See http://www.xldynamic.com/source/xld.ColourCounter.html -- HTH Bob Phillips Thanks Bob, Works like a charm - any idea on making it update dynamically on change of cell colour ? As it stands I have to activate the cell with the formula and click in the formula bar to make it update. Tried F9 but no luck. Cheers Dave. |
#5
|
|||
|
|||
"Bob Phillips" wrote in message
... It cannot be fully dynamic Dave as the cell colour change does not trigger the recalc. You can make it respond to F9 by adding Application.Volatile at the start of the Colorindex function. -- HTH Bob Phillips Ah that's better - ta Bob. |
Reply |
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 |