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.

Adding more than 3 cells (2003)produces "0" but no error message
 

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.

Adding more than 3 cells (2003)produces "0" but no error messa
 

Thank You!! If I sent it would it help? What I have is a sales tracking
spreadsheet with aver 25 worksheets...1 for each week. I list data about
each order & subtotal each day. I keep a running total - week-to-date by
adding the subtotal for each day. I've used the spreadsheet since
March...adding a worksheet a week & a few graphs...It wasn't until recently
(the last month, perhaps) that it didn't work just fine!

Another problem...when I Format - Cells - currency - it always formats
Number (the choice above currency) I repeat the command again...& it takes it
and displays it correctly ... as currency! I've been using Excel since
version 1 & I've never experienced anything this frustrating! I'm sure it's
something really simple!

I've also heard that there's an "auto subtotal" feature??????
Thanx so much!

"Bernard Liengme" wrote:

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.

Adding more than 3 cells (2003)produces "0" but no error messa
 

Send me (private mail) a copy of your file.
Add some notes telling what you want to happen
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"garden girl" wrote in message
...
Thank You!! If I sent it would it help? What I have is a sales tracking
spreadsheet with aver 25 worksheets...1 for each week. I list data about
each order & subtotal each day. I keep a running total - week-to-date by
adding the subtotal for each day. I've used the spreadsheet since
March...adding a worksheet a week & a few graphs...It wasn't until
recently
(the last month, perhaps) that it didn't work just fine!

Another problem...when I Format - Cells - currency - it always formats
Number (the choice above currency) I repeat the command again...& it takes
it
and displays it correctly ... as currency! I've been using Excel since
version 1 & I've never experienced anything this frustrating! I'm sure
it's
something really simple!

I've also heard that there's an "auto subtotal" feature??????
Thanx so much!

"Bernard Liengme" wrote:

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.

Adding more than 3 cells (2003)produces "0" but no error messa
 

My email was returned! Please give me your email address exactly as I should
use it! Thanx!

"Bernard Liengme" wrote:

Send me (private mail) a copy of your file.
Add some notes telling what you want to happen
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"garden girl" wrote in message
...
Thank You!! If I sent it would it help? What I have is a sales tracking
spreadsheet with aver 25 worksheets...1 for each week. I list data about
each order & subtotal each day. I keep a running total - week-to-date by
adding the subtotal for each day. I've used the spreadsheet since
March...adding a worksheet a week & a few graphs...It wasn't until
recently
(the last month, perhaps) that it didn't work just fine!

Another problem...when I Format - Cells - currency - it always formats
Number (the choice above currency) I repeat the command again...& it takes
it
and displays it correctly ... as currency! I've been using Excel since
version 1 & I've never experienced anything this frustrating! I'm sure
it's
something really simple!

I've also heard that there's an "auto subtotal" feature??????
Thanx so much!

"Bernard Liengme" wrote:

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.