Multiple Cell Formula

**Phil_L79** · 03-15-2011, 10:39 AM

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

**Cutter** · 03-15-2011, 11:37 AM

Why is there a blank col (G) on the Result sheet?

**Phil_L79** · 03-15-2011, 11:44 AM

no exact reason just a spacing as I want only blocks of 5 months

**arthurbr** · 03-15-2011, 11:52 AM

Phil,

this is the third time you post the same problem.

Please have a look at forum rules about duplicate posting.

I closed your other threads and hope that in the future you will abide by the rules.

**Phil_L79** · 03-15-2011, 11:56 AM

Apologies I wasn't sure I had posted it in the correct places. My mistake.

**mahju** · 03-15-2011, 02:55 PM

I am sorry i can't understand your questions.

If you want to have updated calculation sheet for all months and your result tab format does not change, you can copy formula in B6 and B7 across and it will show data for each month (simple)

If you want to see the results one month at a time in column B then use Dget function

see attached

If these are not the cases explain some more.

Thanks

Regards