View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SnoDrift12 SnoDrift12 is offline
external usenet poster
 
Posts: 2
Default 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