counting cells dependant upon different things

[Shelly68]

Hi,

Column D going down has different numbers,

how do I say COUNT how many between 1-9, then 10-19, then 20-21 etc (in the same forumula)

TIA

Shelly

 

[Brian from Maui]

Not sure why you'd want one formula but,

=COUNTIF(Range,">=1")-COUNTIF(Range," > 9")& "Whatever Text" &COUNTIF(Range,">=10)-COUNTIF(Range," > 20)......

 

[Shelly68]

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)

 

[Brian from Maui]

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)

What would you like displayed if the cell value is between 1-10, 11-20 etc? Better yet, provide a small sample and expected results.

 

[Shelly68]

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

 

[Aladin Akyurek]

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

Book8
	A	B	C	D	E
1	1		1	10	7
2	3		11	20	5
3	9		21	30	4
4	7
5	11
6	5
7	18
8	17
9	13
10	12
11	6
12	4
13	21
14	24
15	25
16	26
Sheet1

E1, copied down:

=COUNTIF($A$1:$A$16,">="&C1)-COUNTIF($A$1:$A$16,">"&D1)

 

[Shelly68]

Thank you very much

 

[Shelly68]

Thank you very much

 

[PaddyD]

or, having set up the data analysis feature by installing the analysis tool pack (tools | addins), use the histogram feature (tools | data analysis)