Sum a range of cells using HLookup or VLookup, sumifs

Hello,

I am having trouble finding a formula that will sum a range of cells based on a date value that is looked up by HLookup. I need the trailing twelve month values inlcuding this value summed.

I have years worth of financial date that is sorted in columns by month and year. I want to be able to look up month and year and have the the twelve months prior this date including this date summed. I know I can do a HLook up based on the month and year which will pull up only one value for that month and year instead of adding the trailing twelve month values.
To clarify, i don't need the formula to search for sales and expenses texts in the table. I want the formula to match the dates and sum based on the date info.

I am attaching a picture as an example, a worksheet and a worksheet with the results I want automated hardcoded.

Thank you in advance.

In G13 copied across and down:

=INDEX($G$4:$X$5,MATCH(MID($F13,FIND(" ",$F13)+1,99),$F$4:$F$5,0),MATCH(G$12,$G$3:$X$3,0))

Or maybe you mean this:

=SUMPRODUCT(($F$4:$F$5=MID($F13,FIND(" ",$F13)+1,99))*($G$3:$X$3 > =$G$12)*($G$3:$X$3 < EDATE($G$12,COLUMNS($G13:G13)))*$G$4:$X$5)

It works here. Perhaps if you provide a workbook with expected results manually entered? Then we might have a clue what you are trying to do.

Good luck - I have to go off to work now.

This returns what your sample results wb shows. In G13 filled down and across.

Formula:

Please Login or Register  to view this content.

This also in G13 filled down and across.

Formula:

Please Login or Register  to view this content.

You are welcome. Glad to help. Thank you for the feedback and added rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Or in G13 copied right

Formula:

Please Login or Register  to view this content.

In G14 Copied right

Formula:

Please Login or Register  to view this content.