Between Formula

[honeybun]

Guys, having a brainless day today, I have a coloumn of figures and i need a standard formula which counts which cells are between a certain set of numbers i:e

=COUNTIF(JAN!L:L,"is between 0 and 4")

can't seem to get my head round it, any one able to help please?

 

[Richard Schollar]

=COUNTIF(JAN!L:L,">=0")-COUNTIF(JAN!L:L,">4")

Richard

 

[honeybun]

Thank you,

told you I was having a bad Day