simple question

[theanalyst]

I've got a list of ages (20, 23, 24, 75 etc.) in a column. I'm trying to count how many are between 19 and 29 for example. how would I do that?

any help would be awesome! thanks

 

[Juan Pablo González]

=COUNTIF(TheRange,">=19") - COUNTIF(TheRange, ">29")

for an inclusive count.

 

[theanalyst]

thanks juan! you're a big help!

 

[Juan Pablo González]

Glad that worked !

 

[theanalyst]

my mistake! I thought that was the formula I used before but it isn't, and it isn't working. It must be some small error with my setup or the formula??? does anyone know?

 

[fairwinds]

Juans formula is OK and should work.

Take a look here and see if it helps.

You can also se an alternative formula there.

02_11.xls
	A	B	C	D
1
2	15
3	16
4	25
5	39
6	19
7	20		6
8	21
9	22		6
10	23
Sheet2