Pivot Table Question - Similar Data over Multiple Columns

Hello all -

I have a quick question - it may be a simple answer...

How can I summarize similar criteria across multiple columns? Attached is my data I am trying to summarize; basically I would like to summarize my table by ages and gender, so that i can quickly see a summary of ages by gender which I can then group (0-2 / 2-4 / 4-6 etc. by male or female).

Alternately - if a basic formula is easier, I can do that as well..

Thanks all!
Jeff

Try to change the layout of the data. See if this solution meets your needs