Sorry, I probably didn't word it correctly then.
If I have a column with numbers that could be anywhere between 1-50 (for example), how do I count those that are between 1-10, 11-20, 21-30 (would this then have to be on the same formula),
so that if it's not between 1-10 look at 11-20 (gosh, I don't know how to explain this clearly)
ADVERTISEMENT
Okay, here goes
A
1
3
9
7
11
5
18
17
13
12
6
4
21
24
25
26
I want to know how many are between 1-10 (so the answer here would be 7), between 11-20 (the answer here is 5), between 21-30 (answer here is 4) and so on. I am not sure if I need to count or sum etc etc (so please excuse the error if I'm made one in my question). TIA Shelly