| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Should grand total equal average of sub total
-- Thanks, Bonnie |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Should grand total equal average of sub total
Nope, if you made money every day that subtotaled 100 per week for 4 weeks
your grand total would be 400, average of subtotals would give you 100. Sum of all subtotals is the grand total -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "Bonnie" wrote: -- Thanks, Bonnie |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Should grand total equal average of sub total
John,
Thank you so much for your help. Your explanation makes sense to me and answers my othe question which was which average is the true answer. Your time to help me will really make a big difference in my task and my ability to check my work correctly. -- Thanks a million, Bonnie "John Bundy" wrote: Nope, if you made money every day that subtotaled 100 per week for 4 weeks your grand total would be 400, average of subtotals would give you 100. Sum of all subtotals is the grand total -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "Bonnie" wrote: -- Thanks, Bonnie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function Key for Calculating Average? | Excel Worksheet Functions | |||
| Total Not Summing Correctly on Calculated Fields in Pivot Table | Excel Discussion (Misc queries) | |||
| how to keep the total colum | Excel Worksheet Functions | |||
| Using VLookup, Displacement, SumIF to total and average | Excel Discussion (Misc queries) | |||
| matching the column b(sku)c(count)with A | Excel Worksheet Functions | |||
Linear Mode
