| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Sum returns #REF instead of total
When I take Auto Sum option it returns #REF instead of totals. Worksheet
integrity seems to be fine. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Auto Sum returns #REF instead of total
On Aug 20, 8:12 pm, Troubled
wrote: When I take Auto Sum option it returns #REF instead of totals. Worksheet integrity seems to be fine. #REF is an error in a direct cell reference. It often appears after deleting some rows or columns. Check the formula for a #REF right in the formula, or a mis-typed reference. Or check all the cells that are being added in the SUM to see if any of them have a bad reference. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AUTO SUM function returns 0.00 and formula displays =SUM() | New Users to Excel | |||
| SUM Calculations Returns #VALUE but displays correct total with "Insert Function"=fx | Excel Worksheet Functions | |||
| Auto sum returns a 0 value in place of sum of values in column. | Excel Discussion (Misc queries) | |||
| Pivots - Auto calc % Sub total is of grand total | Excel Discussion (Misc queries) | |||
| how do i have beginning balance take away an amount auto total | Excel Worksheet Functions | |||
Linear Mode
