You haven't told us what formula you are using to calculate your totals, so
it is stretching the ability of the clairvoyants in the group to explain
what you've done wrong.
--
David Biddulph

"Garf" <Garf @discussions.microsoft.com wrote in message
...
I have a date selection for 13 weeks and have split the weeks in to months
like below

28-Sep
05-Oct
12-Oct
19-Oct
26-Oct
02-Nov
09-Nov
16-Nov
23-Nov
30-Nov
07-Dec
14-Dec
21-Dec

October 0
November 0
December 0

Qtr 4 0

The problem I have is sometimes when i enter data in the weeks the october
sum calculates all 13 weeks whereas the nov and dec stay in their set
parameteres, I could just apply absolutes but its an extremely long job,
is
there anything i can turn off that makes it self calculate?