I have a spreadsheet grouped by division and region. Region is the inner
group an division is the outer group
Column A B C D E
age 50-54 55-59 60&
Region A 50
Region A 51
Region A totals 2 0 0
Region B 60
Region B 65
Region B totals 0 0 2
Division tot 2 0 2

How do I write a formula in column C3 to subtotal(3,B2:B3) for ages between
50 and 54 in cell C4, between ages 55 and 59 in cell D4, etc then total the
regional totals in the age categories for each division.

This is a simplistic example there are hundreds of ages in each region and
there are 8 divisions