View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
garden girl garden girl is offline
external usenet poster
 
Posts: 1
Default Adding more than 3 cells (2003)produces "0" but no error message

I have a spreadsheet with 26 worksheets ( 20 weeks of sales data - only A-L
and about 40 rows). I add daily subtotals for a week to date running total.
Several weeks ago when I went to add the 3rd day it would "calculate" "0.00."
There is no error message. I can manually insert the totals from each day &
it'll add...I've tried copying just one worksheet to a new
worksheet...deleting formulas etc. but, it does the same thing.