quote:
Originally posted by may73alliance
Woah thanks cookie. ive tryed all of them an i get an error saying "the formula you typed contains an error"
Make 100% sure that you typed the formula correctly
Also note that the formula given is in English... Excel is a language dependant application, this means that the formula's are different in different languages.
eg: the English Excel formula SUM() would be SOM() in Dutch Excel, etc...
quote:
Originally posted by may73alliance
What i am trying to do is count how many blocks have a number between 8 and 10 on them in a specific range.
Like first said by Z_Joanna_ZZZ and corrected by me:
* get number of cells in the range A1:A55 which have a value between 8 and 10 (thus excl. 8 and 10):
=COUNTIF(A1:A55;">8")-COUNTIF(A1:A55;">=10")
* get number of cells in the range A1:A55 which have a value from 8 to 10 (thus incl. 8 and 10):
=COUNTIF(A1:A55;">=8")-COUNTIF(A1:A55;">10")
quote:
Originally posted by serpico
try http://support.microsoft.com they have a great database for excel
Excel comes with a very extensive helpfile already, pressing F1 is all it takes
quote:
Originally posted by saralk
ok, i just made a simple formula now, it works for me, but its not inclusive
=COUNTIF(A1:H1, ">8")-COUNTIF(A1:H1, "<10")
That's wrong and wont give the correct result, it should be ">", not "<". And if you want to make it between 8 and 10 (thus not including 8 and 10), it should even be ">=10"
Besides, the (almost correct) formula was already given in the second post of this thread (and again in my first post)
quote:
Originally posted by may73alliance
Cheers Saralk the formulae actually gives a result but not the right result. lolololol. hmmmm isnt it possible to do =COUNTIF(A1:H1, "8to10") sort of thing.
read my first post in this thread?
/ 
