Bob Phillips Wrote:
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


That link says that for what I'm looking for, the following should
work

Code:
--------------------
=SUMPRODUCT(--(ColorIndex(B10:X66)=39))
--------------------

Problem is, I'm getting a name? at the ColorIndex part.


--
DKY
------------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=499846