Count how many between set ages

[jwallace90]

Hi,

if anyone can help that will be great.

I am looking for a COUNTIF type formula that can count how many number 1 there is for ages between 20-25 and then another for number 1 between 26-31 for example.

i've attached the type of criteria i would need.

Ideally i wouldn't like to use Pivot tables as im trying to put the data onto a hidden sheet and have the information on one front sheet with graphs etc.


thank you very much

[Glenn Kennedy]

Use this:

=COUNTIFS(A:A,1,B:B,">=20",B:B,"<=25")

and this:

=COUNTIFS(A:A,1,B:B,">=26",B:B,"<=31")