Counting age group between dates

[xxsalahxx]

Hello I'm trying to count age groups between dates such as 01/01/2014 to 31/12/1014.

I have the following working for age 16 and under however I have other age groups such as "age 17 to 25" "26 to 30" "13 to 40"not sure how to do this is there anyone who can suggest how I can do this?

=SUMPRODUCT(IF((Data!A2:A20>=A1)*(Data!A2:A20<=A2),1*(COUNTIF(Data!B2:B20,"<=16"))))

I have a data sheet and an analysis sheet

Thank you in advance, any help is much appreciated

 

[Marcelo Branco]

I don't think your formula works for ages <=16.
It should be
=SUMPRODUCT(--(Data!A2:A20>=A1),--(Data!A2:A20<=A2),--(Data!B2:B20<=16))

For ages 17 to 25 try
=SUMPRODUCT(--(Data!A2:A20>=A1),--(Data!A2:A20<=A2),--(Data!B2:B20>=17), --(Data!B2:B20<=25))

M.

 

[xxsalahxx]

I don't think your formula works for ages <=16.
It should be
=SUMPRODUCT(--(Data!A2:A20>=A1),--(Data!A2:A20<=A2),--(Data!B2:B20<=16))

For ages 17 to 25 try
=SUMPRODUCT(--(Data!A2:A20>=A1),--(Data!A2:A20<=A2),--(Data!B2:B20>=17), --(Data!B2:B20<=25))

M.

Thank you so much this works a treat!

 

[Marcelo Branco]

You are welcome. Glad to help.

M.