| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Totals: Group totals different from Grand totals | Excel Discussion (Misc queries) | |||
| Totals of calculated field in pivot table give incorrect results | Excel Worksheet Functions | |||
| Incorrect totals in Pivot Table | Excel Discussion (Misc queries) | |||
| incorrect totals using rounded numbers | Excel Discussion (Misc queries) | |||
| Comparing/matching totals in a column to totals in a row | Excel Worksheet Functions | |||
Threaded Mode
