Sum of coloured cells in execel 2007

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shane - 26 Apr 2007 08:46 GMT

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

Reply to this Message

Bob Phillips - 26 Apr 2007 11:10 GMT

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

Signature

HTH

Bob

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

> 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

Reply to this Message

Peo Sjoblom - 26 Apr 2007 18:10 GMT

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

Signature

Regards,

Peo Sjoblom

> It will filter and sort coloured cells but I don't think there is a count
> facility.
[quoted text clipped - 10 lines]
>>
>> Thanks

Reply to this Message