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
Border formatting row of cells 22
Function for summing or counting cells based on a specified fill color 3
Count cells with the red color 1
Help using Chip Pearsons code to count cells with color 9
SUMPRODUCT and SUMIFS combined with Sumifbycolor (VBA code) 1
Return the color of a cell 1
counting coloured cells 3

Top