Count cells with the red color

[Collcat]

Thanks for the links.

I have ben trying : *=SUMPRODUCT(--(ColorIndex(A1:A100)=3))* (fro
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,
Coolca

 

[Frank Kabel]

Hi
you need to put the macro code in a standard module of your workbook
first. See:
http://www.mvps.org/dmcritchie/excel/getstarted.htm