I'm trying to use a cell reference in a COUNTIF statement:

=COUNTIF(C:C,""&G1)

For some reason I can't make the formula work. According all I've read,
this is the syntax that I should use.

There's nothing wrong with your formula.

I can't make the formula work

What exactly does that mean?

Biff

"Kenny Newbry" wrote in message
...
I'm trying to use a cell reference in a COUNTIF statement:

=COUNTIF(C:C,""&G1)

For some reason I can't make the formula work. According all I've read,
this is the syntax that I should use.

It works for me. In what way does it not work? I assume G1 contains a
number.
__________________________________________________ ______________________



"Kenny Newbry" wrote in message
...
I'm trying to use a cell reference in a COUNTIF statement:

=COUNTIF(C:C,""&G1)

For some reason I can't make the formula work. According all I've read,
this is the syntax that I should use.

The formula returns a value of "0" regardless of the contents of the
referenced cell. When I open the function window and look at the Criteria
field, it shows #VALUE! out to the right. No matter what I put in the
referenced cell, what cell I choose to reference, or what range I select
that's what I come up with. If I replace the cell reference with the value
of the referenced cell inside the quotes it works fine, but I cannot get it
to accept a reference.

"T. Valko" wrote in message
...
There's nothing wrong with your formula.

I can't make the formula work

What exactly does that mean?

Biff

"Kenny Newbry" wrote in message
...
I'm trying to use a cell reference in a COUNTIF statement:

=COUNTIF(C:C,""&G1)

For some reason I can't make the formula work. According all I've read,
this is the syntax that I should use.

if you do not use the ""& and just put in the cell reference, do you still
get the #Value in the function window, If so , you probably have a corrupted
program?
if it is OK,try < and = and see what you get.
you might be able to use a workaround of
=counta(C:C)-Countif(C:C,"<="&G1)

I also do not know why, but I occassionally have to put spaces around the &
for a fuction to work correctly.


"Kenny Newbry" wrote:

The formula returns a value of "0" regardless of the contents of the
referenced cell. When I open the function window and look at the Criteria
field, it shows #VALUE! out to the right. No matter what I put in the
referenced cell, what cell I choose to reference, or what range I select
that's what I come up with. If I replace the cell reference with the value
of the referenced cell inside the quotes it works fine, but I cannot get it
to accept a reference.

"T. Valko" wrote in message
...
There's nothing wrong with your formula.

I can't make the formula work

What exactly does that mean?

Biff

"Kenny Newbry" wrote in message
...
I'm trying to use a cell reference in a COUNTIF statement:

=COUNTIF(C:C,""&G1)

For some reason I can't make the formula work. According all I've read,
this is the syntax that I should use.