Some aspects of excel are a mystery to me!
This probably is very simple for someone else.

I want to analyse some data in every second cell in one column.
What I want to do is count the number of cells that contain data that is between say, 20 and 30, but not including those numbers.
E.g.
A
1 14
2 45
3 27
4 32
5 25
6 23
7 29
8 9

On this I would want to look at cells A2, A4, A6 and A8. The formula would give me an answer of 1 for my criteria.

I have tried countif, which says I have too many arguments. Countifs says Ihave too few.

If I use a continuous range, I can do it. It is when I try to do every second cell that I hit problems.

Suggestions will be gratefully welcome.

Regards

RalphCr