If your formula is referring to column 4 but you are seeing a column 3
result, then I suspect that in Tools/ Options/ Calculation you may have
selected Manual where you ought to have Automatic.
--
David Biddulph

"RMP" wrote in message
...
Thanks again Max that is very helpful.

I have managed to replicate the formula in from B3 to F3, J3 and N3.

Is there any easy way of copying the formula from B3 to B4. I have tried
to
drag the formula down but it's copying the result from B3 even though the
formula refers to the sum of B4, F4, J4 and N4 on the Week 1 sheet.

I hope to be able to enter the formulas in the top row and drag them all
the
way down.

Thanks again.
--
RMP

"Max" wrote:

You seem to have things neatly arranged & under control as far as I can
see
?
(your layout is not suitable for pivot, but this is not relevant here)

Eg your typical point cell formula in Weekly Summary's B3:
=SUM('Week 1'!B3,'Week 1'!F3,'Week 1'!J3,'Week 1'!N3,'Week 1'!R3)
is easily propagatable across/down for the week

Similarly with the next one in F3:
=SUM('Week 2'!B3,'Week 2'!F3,'Week 2'!J3,'Week 2'!N3,'Week 2'!R3)

And the same thing goes for the formulas in Monthly Summary

Maybe just a small point on using Edit Replace for replicating formulas
in
this kind of scenario:
To "replicate" B3's formula for F3. You could say, remove the equal sign
temporarily in B3's formula, then copy the formula n paste into F3. Then
just use EditReplace to replace (in F3): Week 1 with: Week 2, then
re-instate both equal signs in B3 & F3.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"RMP" wrote in message
...
Thanks Max,
I have uploaded the file, please access on the link below.

http://www.freefilehosting.net/download/3a323

Look forward to hearing back from you.
--
RMP