Hello all,

I am trying to count the number of cells based on a given value. The
problem is, every time I add a new value that I want added to my
calculation, I have to go back and add the new value to each
calculation cell.

Here's an example of a calculation I have. Just the $S$47 and $T$47 are
different. Now, the next time I add a new value, I'll have to add
another 'countbycolor' string to this calculation. Now what I'd like to
be able to do is have it just count based on a range of cells that I
give it which would contain all of my lookup values.

=COUNTBYCOLOR(J27:P32,$S$47,FALSE) + COUNTBYCOLOR(J27:P32,$T$47,FALSE)

Any thoughts?


--
bimmerman
------------------------------------------------------------------------
bimmerman's Profile: http://www.excelforum.com/member.php...fo&userid=2623
View this thread: http://www.excelforum.com/showthread...hreadid=570126