G
Guest
Pseudo code
Count if greater than value in a reference cell
Cell C3 would be:
=COUNTIF(A1:A8,">=$B$1")/8
Count if greater than value in a reference cell
Cell C3 would be:
=COUNTIF(A1:A8,">=$B$1")/8
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Stephany Young
And your point is .... ?
G
Guest
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?
$B$1 never works
but an actual number works
=COUNTIF(A1:A8,">=0.02")/8
How can I use countif using an absolute references?
R
richardjking
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?
- 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.
R
richardjking
=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.