COUNTIF cell reference won't work

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kenny Newbry - 26 Jun 2007 19:10 GMT

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.

Reply to this Message

T. Valko - 26 Jun 2007 19:25 GMT

There's nothing wrong with your formula.

>I can't make the formula work

What exactly does that mean?

Biff

> 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.

Reply to this Message

Kenny Newbry - 26 Jun 2007 19:31 GMT

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.

> There's nothing wrong with your formula.
>
[quoted text clipped - 10 lines]
> > For some reason I can't make the formula work. According all I've read,
> > this is the syntax that I should use.

Reply to this Message

bj - 26 Jun 2007 19:59 GMT

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.

> 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
[quoted text clipped - 18 lines]
> > > For some reason I can't make the formula work. According all I've read,
> > > this is the syntax that I should use.

Reply to this Message

Vasant Nanavati - 26 Jun 2007 19:28 GMT

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

Reply to this Message