Thanks for the links.

I have ben trying : *=SUMPRODUCT(--(ColorIndex(A1:A100)=3))* (from
xldynamic)

But I get *#NAME?* as a response in my cell.

What am I doing wrong?

I can't get *=ColorIndex(A1)* to work either


Do I have to do some programming first?

Sincerely,
Coolcat


--
Collcat
------------------------------------------------------------------------
Collcat's Profile: http://www.excelforum.com/member.php...o&userid=15598
View this thread: http://www.excelforum.com/showthread...hreadid=272865