View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Garf Garf is offline
external usenet poster
 
Posts: 2
Default incorrect totals

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?