Count number of people between certain ages.

[bablubg]

Dear all,

Good noon. I've a group of people of different ages. Now I want count how many number people are in age between 05-10, 10-15, 15-20, 20-25 etc. What will be the formula in this regard, please help.

[SAI80]

Say Ages are in column B:B

=sumifs($B:$B,">"&5,$B:$B,"<="&10)
note. this counts if age = 10 but does not count if age = 5

=sumifs($B:$B,">"&10,$B:$B,"<="&15)
note. this counts if age = 15 but does not count if age = 10

[bluesky63]

Use lookup

=LOOKUP(F2,$B$2:$B$5,$A$2:$A$5)

[bablubg]

Thanks a lot.

[GeoffW283]

If I am understanding correctly this is tailor made for using the frequency() function.

Ages are randomly set within the range 1 to 80 in cells B2: B26 (extend this range as far as you need)
C2:C17 are the age bins per your 5 year requirement from 0-5 through 75-80

Select D2:D18, click on the formula bar and CTRL-SHIFT-ENTER: (is an array formula)

Please Login or Register  to view this content.

That's it. Counts per bin are now in D2:D18.

See attached