Can you count items in a column by color?
 

I get a spreadhseet daily with updates of work completed in different colors.
Is there a way just to count one color or all of them if need be.

Can you count items in a column by color?
 

hi
yes you can but you may need to install some custom functions first.
see this site for details..
http://www.cpearson.com/Excel/colors.aspx

Regards
FSt1

"Jim N" wrote:

I get a spreadhseet daily with updates of work completed in different colors.
Is there a way just to count one color or all of them if need be.