Count cells with the red color

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Sum Based on Cell Background Color 6
counting coloured cells 3
Count cells with the red color 1
Return the color of a cell 1
Change cell color based on another cell value 8
Border formatting row of cells 22
Excel Countifs/Sumproduct with mutil Or statement 3
Help using Chip Pearsons code to count cells with color 9

Top