I have a number of rows of data with ages of individuals.

I'd like to count the number of ages, but not all individually.

For example, I'd like to count the total number of 6 - 12 year olds in my
column of ages, etc.

I've been using =COUNTIF(A:A, 1) and then adding them all together, but I
don't want to have to do this for all the numbers from 0 - 86 (my highest
number).

Thanks so much.

=SUM(COUNTIF(A:A,{">=6",">12"})*{1,-1})


"Myjogli" wrote:

> I have a number of rows of data with ages of individuals.
>
> I'd like to count the number of ages, but not all individually.
>
> For example, I'd like to count the total number of 6 - 12 year olds in my
> column of ages, etc.
>
> I've been using =COUNTIF(A:A, 1) and then adding them all together, but I
> don't want to have to do this for all the numbers from 0 - 86 (my highest
> number).
>
> Thanks so much.

Assume your ages are in the range A1:A20

Enter you age intervals in a range of cells like this:

......C.....D
1...6.....12
2...13...25
3...26...40

Then enter this formula in E1 and copy down as needed:

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

--
Biff
Microsoft Excel MVP


"Myjogli" <(E-Mail Removed)> wrote in message
news4491615-0E39-479E-A2F3-(E-Mail Removed)...
>I have a number of rows of data with ages of individuals.
>
> I'd like to count the number of ages, but not all individually.
>
> For example, I'd like to count the total number of 6 - 12 year olds in my
> column of ages, etc.
>
> I've been using =COUNTIF(A:A, 1) and then adding them all together, but I
> don't want to have to do this for all the numbers from 0 - 86 (my highest
> number).
>
> Thanks so much.