| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding up multiple cells | Excel Worksheet Functions | |||
| adding specific cells | Excel Worksheet Functions | |||
| adding summed cells in a conditional sumif | Excel Worksheet Functions | |||
| Adding separate accumulators for multiple cells | New Users to Excel | |||
| ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. | Excel Discussion (Misc queries) | |||
Linear Mode
