Getting the sum of two intersecting named ranges

[mam04x]

I have a large table with several years worth of data, organized by date, including year/quarter/month/date. There are then several columns.

I've made the quarters into named ranges; Q1_2012, Q2_2012, Q3_2012, Q4_2012.

I then made the columns into named ranges; Account_A, Account_B, Account_C, etc.

I would like to find the sum of all cells in the column for Account_A where it intersects with the many rows that make up the named range for a specific quarter. I think the way to do it is with some sort of index formula, but I'm not totally sure.

I've attached a file for reference.

Thanks,
Mark