I have a spreadsheet in which i have some numbers in a column for example like this

3
4
6
8
10

Now i want to do a countif on this and only want to count whenever the number is between five and nine (so the answer should be two)

How do i do this within the countif formula. What i do not want is to add an extra column with for instance an IF or an AND formula and do the countif on that extra column. I want to have this solved within the COUNTIF criteria

Use this formula (adjust range to suit)

=SUM(($A$1:$A$10<9)*($A$1:$A$10>5))

But be sure to confirm with CTRL + SHIFT + ENTER (CSE, also called array-entered), rather than ENTER.