Countif the number of entries > x and
Posted by Jamie Riddell on December 14, 2001 1:56 AM
Hello All.
This may seem like an easy question -
I am trying to count the number of times a figure appears in one column (and also the whole worksheet.)
At the moment I can run a =COUNTIF(B10:B73,"<15") Where B10:B73 is my column.
This works for figures less than or greater than.
However, I need to count the number of entries that appear between two values e.g. >15 <30.
Any feedback or advice would be greatly receieved.
Thanks
Jamie