Count cells with the red color

  • Thread starter Thread starter Collcat
  • Start date Start date
C

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
 
Back
Top