No, it will
NOT return the correct result...
Please read my posts carefully, and notice the colored, bold or underlined parts!!!
quote:
Originally posted by CookieRevised
Like first said by Z_Joanna_ZZZ and corrected by me:
* number of cells in range A1:A55 which have a value between 8 and 10 (thus excl. 8 and 10):
=COUNTIF(A1:A55;">8")-COUNTIF(A1:A55;">=10")
* number of cells in range A1:A55 which have a value from 8 till 10 (thus incl. 8 and 10):
=COUNTIF(A1:A55;">=8")-COUNTIF(A1:A55;">10")
notice the
red and
blue parts
if the range is:
5.77
6.45
8.00
8.16
9.51
10.00
10.78
the first formula:
=COUNTIF(A1:A55;">8") - COUNTIF(A1:A55;">=10")
=4 - 2
=2
(because only 8.16 and 9.51 are numbers between 8 and 10)
the second formula:
=COUNTIF(A1:A55;">=8") - COUNTIF(A1:A55;">10")
=5 - 1
=4
(because 8.00, 8.16, 9.51 and 10.00 are numbers from 8 till 10, inclusief 10)
your formula:
=COUNTIF(A1:A55
;">=8")-COUNTIF(A1:A55
;">=10")
=5 - 2
=3 (thus wrong)
=the amount of numbers from 8 (thus incl. 8) to 10 (thus excl. 10)
">" means bigger then. This means that ">8" means bigger then 8... 8 is not bigger then 8 but equal... Thus 8 will not be counted...
">=" means bigger then or
equal to. This means that ">=8" means bigger then 8 or equal to 8... Thus 8 will be counted...
/ 
