See
http://www.xldynamic.com/source/xld.ColourCounter.html
--
HTH
RP
(remove nothere from the email address if mailing direct)
"DKY" wrote in message
...
I have a spreadsheet in which there is a calendar. On this calendar are
cells for the days. In these cells for the days we use colors for
Vacation (Purple), Holiday (Pink), Unpaid Absences(Green) and Late
days(Yellow). At the top of the page I want a cell that tells me the
number of Purples are in a range (B10:X66) and how many pinks, greens
and yellows there are. Is there a way to use the 'Count' to count
colors in a range?
--
DKY
------------------------------------------------------------------------
DKY's Profile:
http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=499846