| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
incorrect totals
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? |
| 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 | |||
![David Biddulph[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
