LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding up multiple cells Andy Excel Worksheet Functions 2 July 11th 06 04:57 PM
adding specific cells Shooter Excel Worksheet Functions 1 January 23rd 06 04:42 PM
adding summed cells in a conditional sumif Tat Excel Worksheet Functions 5 June 12th 05 06:09 PM
Adding separate accumulators for multiple cells jrambo63 New Users to Excel 1 May 26th 05 06:56 PM
ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. Robin Smith Excel Discussion (Misc queries) 0 December 20th 04 08:47 PM


All times are GMT +1. The time now is 08:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"