On Tue, 31 May 2005 18:26:24 +0100, "Bob Phillips"
wrote:

Take a look at http://www.xldynamic.com/source/xld.ColourCounter.html, and
use a formula like

=SUMPRODUCT(--(ColorIndex(A1:A100)=3),--(A1:A1000="G"))


Hi Bob,

Thanks for the suggestion. I shall try it out.


--
Cheers

Peter

Please remove the invalid to reply