counting coloured cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I saw this formula on the message board,

=SUMPRODUCT(--(Colorindex(A1:A50 TRUE)=3))

It is suppose to count the cells that have RED Fonts in them. This is what I
want to try and do. But I get an @name error. It does not like the Command
COLORINDEX.

This Function is not in the Paste Function menu. Where dos it come from.

HELP

Thanks Tony
 
If the cells are colored as a result of Conditional Formatting, then you
could use the same conditions to code a helper column and then sort on
it..............


Vaya con Dios,
Chuck, CABGx3
 

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

is this function correct? 2
Conditional Sum Based on Cell Background Color 6
ColorIndexOfOneCell 8
SUMPRODUCT query 10
Count using Coloured Cells 1
Counting coloured cells? 1
Help using Chip Pearsons code to count cells with color 9
Counting coloured cells 3

Back
Top