| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Getting total
How do I get the row of numbers to add up to a total for the total box on an
expense statement? It won't let you put a number in that box it says Excel has an equation and figures it out by itself...But it never does? |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Getting total
#1: Make sure the formula refers to the correct range of values to be totaled.
#2: Check Tools | Options and on the [Calculation] sheet and make sure that "Automatic" calculation is selected. "JL" wrote: How do I get the row of numbers to add up to a total for the total box on an expense statement? It won't let you put a number in that box it says Excel has an equation and figures it out by itself...But it never does? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 : Any single button to get sub total and grand total ? | Excel Discussion (Misc queries) | |||
| Total column changes colors when total equals sum of other columns | New Users to Excel | |||
| calculate count on 2006 total, 2005 total, etc... | Excel Worksheet Functions | |||
| Pivots - Auto calc % Sub total is of grand total | Excel Discussion (Misc queries) | |||
| Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions | |||
Linear Mode
