Offset Based on Conditions

[macro12]

Hello,

I am trying to create an offset function that changes the tables (highlighted in yellow) based on conditions in E6 and E7. Can someone please help me? I have attached a template below.

Thanks in advance.

[JohnTopley]

It would help if the heading on your tables were consistent. You have months as text in your summary but numbered headings 1-1, 1-2 in the "Budgeted" sheet
where 2 values appear to be summed in the summary.

Can you change heading to dates (01/01/2015) : year is not important. For example 1-1 could be 01/01/2015 and 1-2 02/01/2015.

Please use dates not text. The headings can be formatted as "Jan" etc.

[JohnTopley]

See the attached:

I have changed headings to dates but formatted as your original. Also removed merged cells as these cannot be used in the formulae.

2 similar formulas used:

First table....

=SUMPRODUCT((Budgeted!$A$2:$A$7=TaskOrderSelection)*(Budgeted!$B$2:$B$7=$G5)*(MONTH(Budgeted!$C$1:$Z$1)=MONTH(H$4))*(Budgeted!$C$2:$Z$7))

Second table:

=SUMPRODUCT((Budgeted!$A$12:$A$26=TaskOrderSelection)*(Budgeted!$B$12:$B$26=$G9)*(Budgeted!$C$12:$Z$26)*(MONTH(Budgeted!$C$11:$Z$11)=MONTH(H$8)))

Note the last formula uses cells G9 to G14 rather than E7

[macro12]

Thank you! Wish I could be an Excel expert like you!

[JohnTopley]

Thank you for the feedback. We were all beginners once so just keep practising and use this forum as an aid. I learn a lot from the real experts here.