COUNTIF WITH Absolute references

am 04.11.2007 01:55:03 von gg

Pseudo code
Count if greater than value in a reference cell
Cell C3 would be:
=COUNTIF(A1:A8,">=$B$1")/8

Re: COUNTIF WITH Absolute references

am 04.11.2007 02:23:23 von Stephany Young

And your point is .... ?

"GG" wrote in message
news:2D0C3AE8-FA3A-4D16-9E16-9A9F81ABB57D@microsoft.com...
> Pseudo code
> Count if greater than value in a reference cell
> Cell C3 would be:
> =COUNTIF(A1:A8,">=$B$1")/8
>

Re: COUNTIF WITH Absolute references

am 04.11.2007 02:49:00 von gg

It's not working.
$B$1 never works
but an actual number works
=COUNTIF(A1:A8,">=0.02")/8

How can I use countif using an absolute references?

"Stephany Young" wrote:

> And your point is .... ?
>
>
> "GG" wrote in message
> news:2D0C3AE8-FA3A-4D16-9E16-9A9F81ABB57D@microsoft.com...
> > Pseudo code
> > Count if greater than value in a reference cell
> > Cell C3 would be:
> > =COUNTIF(A1:A8,">=$B$1")/8
> >
>
>

Re: COUNTIF WITH Absolute references

am 21.11.2007 13:59:46 von richardjking

On Nov 4, 1:49 am, GG wrote:
> It's not working.
> $B$1 never works
> but an actual number works
> =COUNTIF(A1:A8,">=0.02")/8
>
> How can I use countif using an absolute references?
>
>
>
> "Stephany Young" wrote:
> > And your point is .... ?
>
> > "GG" wrote in message
> >news:2D0C3AE8-FA3A-4D16-9E16-9A9F81ABB57D@microsoft.com...
> > > Pseudo code
> > > Count if greater than value in a reference cell
> > > Cell C3 would be:
> > > =COUNTIF(A1:A8,">=$B$1")/8- Hide quoted text -
>
> - Show quoted text -

=COUNTIF(A1:A8,">="&$B$1)/8 does not come up with an error, but when I
tried this syntax it didn't give the right answer either.

Re: COUNTIF WITH Absolute references

am 21.11.2007 14:40:58 von richardjking

On Nov 21, 12:59 pm, richardjk...@gmail.com wrote:
> On Nov 4, 1:49 am, GG wrote:
>
>
>
>
>
> > It's not working.
> > $B$1 never works
> > but an actual number works
> > =COUNTIF(A1:A8,">=0.02")/8
>
> > How can I use countif using an absolute references?
>
> > "Stephany Young" wrote:
> > > And your point is .... ?
>
> > > "GG" wrote in message
> > >news:2D0C3AE8-FA3A-4D16-9E16-9A9F81ABB57D@microsoft.com...
> > > > Pseudo code
> > > > Count if greater than value in a reference cell
> > > > Cell C3 would be:
> > > > =COUNTIF(A1:A8,">=$B$1")/8- Hide quoted text -
>
> > - Show quoted text -
>
> =COUNTIF(A1:A8,">="&$B$1)/8 does not come up with an error, but when I
> tried this syntax it didn't give the right answer either.- Hide quoted text -
>
> - Show quoted text -

Just tried it again, and it did work, it just didn't update properly
the first time, maybe due to the large number of calculations in the
spreadsheet.