Search Row for 2 Matches and Sum Collumn Below

Hi guys,

Thank you very much for your help! I have a much larger sheet and I attempted to extract some of the data and make the file (Excel Help Forum.xlsx), but can see I wasn't clear enough (my apologies!). Unfortunately none of the above formulas work when the start month is a jon-January one.

The 12-month forecast has the option to select a different start month, consequently meaning that some of the latter months will go over into the next year.

I have now taken a snippet of the actual Workbook which should make it more clearer. For this example Month1 is May 2026. January to April is in the following year (2027).

I have coloured the desired cells in green on the Forecast! sheet. They need to use the month in the cell directly above and the year two cells up and one to the right (eg. Month1/cell F17 = Month F16; Year G15).

From the Revenue! sheet, you can see the Years and Months are all listed on row8 (big sheet), and I want the sum of the 50 rows below returned.

If this is impossible to do on 1 line, I can always copy the year into the cells above every month (row7) and hide it in white font.

Thank you all again.

Danny