Sum formula of cells with specific color value
Hello,
I am trying to ceate a SUM formula to add only the green filled cells in a specified range. I am trying to do it with sum and cell("color",reference) but I can't seem to be able to find color values. A formula of: SUM(A3:E3) =CELL("color") simply returns a TRUE value. Any help would be appreciated. Thanks, Lia |
Sum formula of cells with specific color value
See http://www.xldynamic.com/source/xld.ColourCounter.html
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "MSOChick" wrote in message ... Hello, I am trying to ceate a SUM formula to add only the green filled cells in a specified range. I am trying to do it with sum and cell("color",reference) but I can't seem to be able to find color values. A formula of: SUM(A3:E3) =CELL("color") simply returns a TRUE value. Any help would be appreciated. Thanks, Lia |
Sum formula of cells with specific color value
Thanks so much! I found a VB that would counts the colors successfully, but
not when text or numbers were added to the cell. "Bob Phillips" wrote: See http://www.xldynamic.com/source/xld.ColourCounter.html -- HTH Bob Phillips (remove nothere from email address if mailing direct) "MSOChick" wrote in message ... Hello, I am trying to ceate a SUM formula to add only the green filled cells in a specified range. I am trying to do it with sum and cell("color",reference) but I can't seem to be able to find color values. A formula of: SUM(A3:E3) =CELL("color") simply returns a TRUE value. Any help would be appreciated. Thanks, Lia |
All times are GMT +1. The time now is 11:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com