Hi, I have tried to count the colours on a spreadsheet. I have copied
Pearson Consulting functions for counting colorindex, which I have managed to
get working when at another company, but when I put the formula
=SUMPRODUCT(--(ColorIndex(A1:A100,TRUE)=3)) in I get the #NAME? Error message.

I have also tried the formula Ossie mac posted but I also get the #NAME?
error. I am using 2003.

Am I missing something?

Davie