countif more than x but equal to or less than x

[superspurs]

I cant figure out this one out, where to put the greater lesser signs etc.

I want to do say more than 0, but equal or less than 5, counting all matching entries in one column?

help appreciated.

[daddylonglegs]

Hello superspurs - great name!

You can use 2 countifs like this

=COUNTIF(A:A,">0")-COUNTIF(A:A,">5")