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):

Timing of Acquisitions
	Jan	Feb	Mar	Apr	May	Jun
Acq1		1
Acq2				1
Acq3						1

<colgroup><col><col span="6"></colgroup><tbody>
</tbody>

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):

Typical Acquisition Profile	Month
	1	2	3	4	5	6
Turnover	1200	1000	900	1300	1250	1500
Cost of Sales	-900	-800	-750	-1100	-1050	-1325
Profit	300	200	150	200	200	175

<colgroup><col><col span="6"></colgroup><tbody>
</tbody>

So the output in April for example would be the Month 3 turnover from Acq1 and Month 1 turnover from Acq2:

Output
	Jan	Feb	Mar	Apr	May	Jun
Turnover	0	1200	1000	2100	2300	3350
Cost of Sales	0	-900	-800	-1650	-1900	-2700

<colgroup><col><col span="6"></colgroup><tbody>
</tbody>

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