Calculating Sumproduct across different months

[apc1968]

Hi - I have three acquisitions which will occur in different months (i.e. one in Feb; one in Apr etc):

[TABLE="width: 695"]
<colgroup><col><col span="6"></colgroup><tbody>[TR]
[TD="colspan: 2"]Timing of Acquisitions[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[TD]Apr[/TD]
[TD]May[/TD]
[TD]Jun[/TD]
[/TR]
[TR]
[TD]Acq1[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Acq2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Acq3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1
[/TD]
[/TR]
</tbody>[/TABLE]

When acquired, each acquisition will then have the same profile of revenue and cost (i.e. the first month of each acquisition will have a revenue of £1,200 etc):

[TABLE="width: 695"]
<colgroup><col><col span="6"></colgroup><tbody>[TR]
[TD]Typical Acquisition Profile[/TD]
[TD="colspan: 6"]Month[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]Turnover[/TD]
[TD]1200[/TD]
[TD]1000[/TD]
[TD]900[/TD]
[TD]1300[/TD]
[TD]1250[/TD]
[TD]1500[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cost of Sales[/TD]
[TD]-900[/TD]
[TD]-800[/TD]
[TD]-750[/TD]
[TD]-1100[/TD]
[TD]-1050[/TD]
[TD]-1325[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Profit[/TD]
[TD]300[/TD]
[TD]200[/TD]
[TD]150[/TD]
[TD]200[/TD]
[TD]200[/TD]
[TD]175
[/TD]
[/TR]
</tbody>[/TABLE]


So the output in April for example would be the Month 3 turnover from Acq1 and Month 1 turnover from Acq2:
[TABLE="width: 695"]
<colgroup><col><col span="6"></colgroup><tbody>[TR]
[TD]Output[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[TD]Apr[/TD]
[TD]May[/TD]
[TD]Jun[/TD]
[/TR]
[TR]
[TD]Turnover[/TD]
[TD]0[/TD]
[TD]1200[/TD]
[TD]1000[/TD]
[TD]2100[/TD]
[TD]2300[/TD]
[TD]3350[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cost of Sales[/TD]
[TD]0[/TD]
[TD]-900[/TD]
[TD]-800[/TD]
[TD]-1650[/TD]
[TD]-1900[/TD]
[TD]-2700[/TD]
[/TR]
</tbody>[/TABLE]


Whilst I can do this for low volumes with lookup or index/match; I will have a lot of Acquisitions and a large P&L - can I use a database function to perform a single calculation?

Thanks to all for helping