COUNTIF cell reference won't work

[Kenny Newbry]

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.

 

[T. Valko]

There's nothing wrong with your formula.

I can't make the formula work

What exactly does that mean?

Biff

 

[Vasant Nanavati]

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

 

[Kenny Newbry]

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.

 

[Guest]

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.