| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autosum returns zero balance - why?
Excel 2003
I've been adding both contiguous and non-contiguous numbers using the autosum function OR =c2+c5+c9 OR =SUM(c2,c5,c9) OR =SUM(a1:a50). In a few places I now get a zero where once the total appeared. I've tried locating a circular reference error but there isn't one. I've been using these formulas for years and never had a problem like this before. What am I missing? Please help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index with mulitple value returns and muliple column returns | Excel Worksheet Functions | |||
| Date returns always returns: 00 January 1900 | Excel Worksheet Functions | |||
| Autosum returns 0 value on data sheet | Excel Worksheet Functions | |||
| rent received/balance owed/running balance spreadsheet | Excel Discussion (Misc queries) | |||
| Autosum returns an incorrect zero value on the selected cells | Excel Worksheet Functions | |||
Linear Mode
