A bit confusing. Tell us how the data is set out. Explain "I went to add the
3rd day it would calculate 0.00" - where is this calculation? what is the
formula.
We want to help but more detail is needed
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"garden girl" <garden wrote in 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.