sum 2D data in one sheet from another sheet

[m_griff13]

Account	CC	Acc-CC	Descr	Jan	Feb	Mar	Apr
301000	000	301000 000	Alt Rev	0	0	0	0
301000	100	301000 100	Alt Rev	500	500	200	400
301001	000	301001 000	Revenue	5000	8000	10000	6000
301001	100	301001 100	Revenue	0	2000	5000	8000
301001	200	301001 200	Revenue	10000	5000	2000	6000
310000	000	310000 000	Track Rev	2000	6000	5000	4000
310000	100	310000 100	Track Rev	8000	4000	5000	6000

<tbody>
</tbody>

2nd Table	Feb	%of Rev	Prior Feb	Q1	Q2
301000
301001
310000 000
310000 100

<tbody>
</tbody>

I have a large set of data on a Sheet{Curr_Data}E6:Q1000, and on another Sheet {Trend} I would like to sum by account, for a particular month or account-CC . Say all account 301001 and for Feb this month and Mar for next month. In 2nd Sheet I would like to have a formula that would be looking to sum all 301001 for Feb based on the second sheet below. Then, when I switch months give me Mar and so on. As you can see some accounts are summarized by account & others by Account-CC. I need a formula that is dynamic with 2nd table I have tried SUMPRODUCT: =SUMPRODUCT((Acct=$B23)*(Mnth=E$20)*Data) Named ranges.

Thank you.