I tried:

=countcol(a1:a100,-4142)

and I got 22,000 or so for the answer. I think what it is doing is counting
every no fill space rather than just the spaces that have text and no fill.
Is there another color index # for "no fill" b/c I know the code I copied to
create this function works?

Thanks for your help.

"Kevin B" wrote:

Try the following value, which corresponds to the Excel constant which did
not work:

-4142
--
Kevin Backmann


"Studebaker" wrote:

Hello Kevin B,

I did and it returned a #Value! error.
I wrote it like this: countcol(a1:a100,xlNone)

Did I write it incorrectly?

Thanks,
Kris

"Kevin B" wrote:

Try using the Excel constant xlNone where you have the color index number in
your function

--
Kevin Backmann


"Studebaker" wrote:

Hello,

I copied a function called "CountCol" which will help me count the colored
cells in my spreadsheet. I have to type the following function in my
spreadsheet,
=countcol(a1:a100,6), and it will count--in this case--all the cells in the
range a1:a100 that have color yellow (6 stands for the color index which
equals yellow).

What is the color index for "no fill"?
(I want to count all the cells with text which have no fill)

Thanks for your help!