| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why won't my spreadsheet SUM??? Help
Having used lotues1-2-3 for 8 years to prepare income tax repoerts, I am now
using Excel for the first time. I copied my Lotus Workbook, to an Excel workbook. It has 12 identical sheets (1/month) which I "sum" 8 columns and then "sum' the same cell from each sheet onto a summary sheet. The problem is 4 of my columns "sum" accurately on row 100, while the other 4 ony display zero(0). I have tried copying from the cells with correct sums, checked the format, but for the life of me cannot figure out why these columns won't add up! =sum(b18:b99) ... should read 4500 .... displays zero. please help, my taxes are already late!!! Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| link a local spreadsheet to a network shared spreadsheet | Setting up and Configuration of Excel | |||
| In Excel I want to copy text from spreadsheet to spreadsheet | Excel Worksheet Functions | |||
| conversion of MS Works Spreadsheet to Excel 2002 Spreadsheet | Excel Discussion (Misc queries) | |||
| Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
| How do I convert exel spreadsheet to works spreadsheet? | Excel Discussion (Misc queries) | |||
Threaded Mode
