multiple cell formula

I need help trying to create a formula to pull through figures for a range of cells.

In the attached workbook I have 2 tabs – Result & Calculation.

On the result worksheet I have 8 months all with a price and pages totals. These numbers are then used by the calculation worksheet to produce the grand total.

On the calculation worksheet I have the Price & Pages totals from the result sheet and then some costs calculations based on the Price & Pages numbers. This then gives me the Grand Total which I then show back on the Results worksheet.

What I want to do is find a way of automatically changing the Price & Pages totals on the calculation sheet for each month as per the results page figures so I can then return the Grand Total figure for each month to the results worksheet in as smooth and quick as way as possible.

I have a much broader range of dates etc on my actual worksheet but have simplified it for this example.

All help would be much appreciated

Duplicate post

http://www.excelforum.com/excel-gene...l-formula.html

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.