On Sun, 26 Jun 2005 11:22:02 -0700, mahmon
wrote:
BRILLIANT IT WORKS! thanks for your help.
You're welcome. Thank you for the feedback.
one more question, how do then
cross reference to values in another column? i have a second coloumn that has
either a blank of the word 'selected' in it. how do i then count all the same
criteria but only if they are 'selected' ?
If your Colors are in a range named "Colors" (or use the appropriate cell
reference); and your column that may or may not have "Selected" in it is in a
range named "Sel" then
with the color of interest in A1:
=SUMPRODUCT((A1=Colors)*(Sel="Selected"))
--ron
|