J
jfj3rd
Hi everyone.
I have columns of numbers.
1
1
7
2
1
1
1
3
5
1
1
1
1
1
2
The spaces represent spacers between clients.
What I'd like to do is find out how many #1's there are, how many are
under 10, how many are under 20 and how many are under 30.
Using CountIf(Range, "<1") works until it finds 11 or any numeral with
a 1 in it. I come across this problem and not sure how to tell CountIf
if it finds 1 by itself THEN count. If not then don't count.
SumIf gives me the grievance of adding the numbers together that are
all under 10, 20 or 30. I don't want this though.
Can anyone help me with this? Any other operation I can use?
Help would be APPRECIATED!
I have columns of numbers.
1
1
7
2
1
1
1
3
5
1
1
1
1
1
2
The spaces represent spacers between clients.
What I'd like to do is find out how many #1's there are, how many are
under 10, how many are under 20 and how many are under 30.
Using CountIf(Range, "<1") works until it finds 11 or any numeral with
a 1 in it. I come across this problem and not sure how to tell CountIf
if it finds 1 by itself THEN count. If not then don't count.
SumIf gives me the grievance of adding the numbers together that are
all under 10, 20 or 30. I don't want this though.
Can anyone help me with this? Any other operation I can use?
Help would be APPRECIATED!