Sum of coloured cells in execel 2007

[Guest]

Please can anyone tell me if Excel 2007 has a function that will count the
number of coloured cells in a range,. I have a column with red, yellow and
blue coloured cells in it and I want to count the number of each colour.

Thanks

 

[Bob Phillips]

It will filter and sort coloured cells but I don't think there is a count
facility.

You can still use this technique
http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Peo Sjoblom]

You can use the subtotal function and auto filter to count and sum coloured
cells in 2007
Filter on a specific colour then use =SUBTOTAL(3,Full_Range) to count them