G Guest Nov 4, 2007 #1 Pseudo code Count if greater than value in a reference cell Cell C3 would be: =COUNTIF(A1:A8,">=$B$1")/8
Pseudo code Count if greater than value in a reference cell Cell C3 would be: =COUNTIF(A1:A8,">=$B$1")/8
G Guest Nov 4, 2007 #3 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?
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?
R richardjking Nov 21, 2007 #4 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 - Click to expand... =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.
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 - Click to expand... =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 Nov 21, 2007 #5 =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 - Click to expand... 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.
=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 - Click to expand... 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.
