Went to the processing colour website as instructed. The formula I need is
=SUMPRODUCT(--(ColorIndex(A2:A28,TRUE)=3))
However, it didn't work. I got *Name in the cell instead of the necessary
number.

I'm trying to search through a list of names (of which some are in blue) and
get it to return the number of names that are in blue. Can you help.

Thanks!