By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,999 Members | 1,303 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,999 IT Pros & Developers. It's quick & easy.

COUNTIF WITH Absolute references

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

Nov 4 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
And your point is .... ?
"GG" <GG@discussions.microsoft.comwrote in message
news:2D**********************************@microsof t.com...
Pseudo code
Count if greater than value in a reference cell
Cell C3 would be:
=COUNTIF(A1:A8,">=$B$1")/8
Nov 4 '07 #2

P: n/a
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" <GG@discussions.microsoft.comwrote in message
news:2D**********************************@microsof t.com...
Pseudo code
Count if greater than value in a reference cell
Cell C3 would be:
=COUNTIF(A1:A8,">=$B$1")/8

Nov 4 '07 #3

P: n/a
On Nov 4, 1:49 am, GG <G...@discussions.microsoft.comwrote:
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" <G...@discussions.microsoft.comwrote in message
news:2D**********************************@microsof t.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.
Nov 21 '07 #4

P: n/a
On Nov 21, 12:59 pm, richardjk...@gmail.com wrote:
On Nov 4, 1:49 am, GG <G...@discussions.microsoft.comwrote:


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" <G...@discussions.microsoft.comwrote in message
>news:2D**********************************@microso ft.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.
Nov 21 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.