Previous Topic Next Topic

Count a cell with particular colour

Closed
Jen - Nov 10, 2009 at 05:33 AM
epsiman Posts 306 Registration date Tuesday November 18, 2008 Status Member Last seen February 2, 2010 - Nov 10, 2009 at 11:24 AM
Hello,

I need a formula in excel to count the cells only if they have a particualr color in it. SAy if the there are 10 cells with some text in each and filled by certain colour. I want the function to count only those cells which ahve say pink clour filled in them..

Can you help me with this?

Regards,
Isha
Related:

1 response

Answer 1 / 1
epsiman Posts 306 Registration date Tuesday November 18, 2008 Status Member Last seen February 2, 2010 162
Nov 10, 2009 at 11:24 AM
Hmmm, i don't think it's possible but the formula to count 10 cells in a row is =sum(C3:C11) for example.

Similar discussions

Counting cells containing only numbers
jutulu -
jutulu -

4 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
If cell A1 has text then cell B2 has today's Date
Sasha -
ac3mark -

1 response
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Instagram not updating people I follow total
Rayinado -
HelpiOS -

1 response