Thanks for the idea, it does not work, when you select the range of the
--(A1:a100="adv") part the range is not in blue.

will the "adv" mean that the cell contains that exactly or it just has to be
part of the cell contents?

Maybe I will just have to count manually, /cry



"Bob Phillips" wrote:

Something like

=SUMPRODUCT(--(ColorIndex(A1:A100,TRUE)=3),--(A1:a100="adv"))

--
HTH

Bob Phillips