incorrect totals

  • Thread starter Thread starter Garf
  • Start date Start date
G

Garf

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?
 
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.
 
Hi David its just a simple sum i.e. October =sum(b2 - b6), Nov b7 - b10, Dec
b11 -b14 and so on but when i enter data for week 6 for example it apples it
to the October formula and when i go back to check it it has reset the
october formula to sum b2 b13, but nov and dec stay as they should, wierd
 
Back
Top