I think he is using the ColorIndex UDF at the link I supplied.


---
HTH

Bob Phillips

"Bernard Liengme" wrote in message
...
You did not tell us that someone has given you a UDF called 'colorindex' -
it is not part of native Excel
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Opal" wrote in message
...
Ah...

So:

=SUMPRODUCT((--(colorindex(B6:B34)=35))*(B6:B34="C"))


thank you!!