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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > There's nothing wrong with your formula.
> >
> > >I can't make the formula work
> >
> > What exactly does that mean?
> >
> > Biff
> >
> > "Kenny Newbry" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > 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.
> > >
> > >
> >
> >
>
>
>
|
Similar Threads
