Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Error
Help!!
I am trying to sum cells in different worksheets to get a total on my summary page but it will not add the cells. This is the formula: =SUM('Jan-Feb 09'!C8, 'Mar-Apr 09'!C8, 'May-June 09'!C8, 'July-Aug 09'!C8, 'Sept-Oct 09'!C8, ' Nov-Dec 09'!C8) Why won't it calculate the cells? -- cjudge |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Error
Are you getting any response?
If no response at all, you might check cell C8 on each tab, and ensure it is not formatted as text. If you are getting an incorrect value, if you copied and pasted the formula from your workbook here, look at your sum for Nov-Dec 09, you have a space after the first apostrophe. -- John C "cdjudge" wrote: Help!! I am trying to sum cells in different worksheets to get a total on my summary page but it will not add the cells. This is the formula: =SUM('Jan-Feb 09'!C8, 'Mar-Apr 09'!C8, 'May-June 09'!C8, 'July-Aug 09'!C8, 'Sept-Oct 09'!C8, ' Nov-Dec 09'!C8) Why won't it calculate the cells? -- cjudge |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Error
Thanks for the quick response, but that isn't it either. Could it be anything
else? -- cjudge "John C" wrote: Are you getting any response? If no response at all, you might check cell C8 on each tab, and ensure it is not formatted as text. If you are getting an incorrect value, if you copied and pasted the formula from your workbook here, look at your sum for Nov-Dec 09, you have a space after the first apostrophe. -- John C "cdjudge" wrote: Help!! I am trying to sum cells in different worksheets to get a total on my summary page but it will not add the cells. This is the formula: =SUM('Jan-Feb 09'!C8, 'Mar-Apr 09'!C8, 'May-June 09'!C8, 'July-Aug 09'!C8, 'Sept-Oct 09'!C8, ' Nov-Dec 09'!C8) Why won't it calculate the cells? -- cjudge |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Error
I fixed the formulas in each worksheet. I had added in the cell that has the
sum which is C8 formula was C4:C8 which is should have been C4:C7. My total was in C8 that's why it would not calculate for me. Thanks for the help though. -- cjudge "cdjudge" wrote: Thanks for the quick response, but that isn't it either. Could it be anything else? -- cjudge "John C" wrote: Are you getting any response? If no response at all, you might check cell C8 on each tab, and ensure it is not formatted as text. If you are getting an incorrect value, if you copied and pasted the formula from your workbook here, look at your sum for Nov-Dec 09, you have a space after the first apostrophe. -- John C "cdjudge" wrote: Help!! I am trying to sum cells in different worksheets to get a total on my summary page but it will not add the cells. This is the formula: =SUM('Jan-Feb 09'!C8, 'Mar-Apr 09'!C8, 'May-June 09'!C8, 'July-Aug 09'!C8, 'Sept-Oct 09'!C8, ' Nov-Dec 09'!C8) Why won't it calculate the cells? -- cjudge |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
error with formula | New Users to Excel | |||
Error formula | Excel Discussion (Misc queries) | |||
Error in my formula? | Excel Discussion (Misc queries) | |||
How do I replace "#N/A" error, to continue my formula w/o error? | Excel Worksheet Functions | |||
Error in a formula | Excel Discussion (Misc queries) |