Count Age range formula ONLY for those who attended

Hello friends,

Please find attached sheet.
In my Excel, Age is calculated automatically based on their DOB. Now I need to prepare a summary of attendance based on the age group. I could use COUNTIF with range but the problem is that I need to consider ONLY those who attended (with F column value is "Y" or "y"). User enters only "y" or "Y" as attendance then automatically summary table (right side) should have the values generated based on the age range count. if F-column (Attended?) is blank or "n" or "N") then they should not be considered for the attendance report (right side).

I entered right side table with hard coded values (numbers) to show the expected output.

I'm using Excel 2013.

Please help!
Many thanks!!