Thread
:
Sum Column Based on Cell Color
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
Sum Column Based on Cell Color
Sum based on the same criteria as how the cells became colored.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Thomas M." wrote in message
...
Excel 2007
Is there a way to sum a column of numbers based on the background color of
the cells? For example, I have a column that contains gold, blue, and
green
cells, and I want to sum only the green cells. The color definition is:
Red 153
Green 204
Blue 0
--
Thanks for any help that you can offer!
--Tom
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett