Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic Sumning of Same Cell from Different Sheets
I'm having difficulty creating a formula that will automatically add the
figures in cell C8 on the current sheet, plus the next 3 sheets. I need cell C8 to remain static, but the current sheet and next 3 sheets to change according to whichever sheet I use that formula in. For example, A formula where it sums up the figures from C8 on the current sheet, being sheet1, plus the next 3 sheets, being sheet2, sheet3 and sheet 4...then The same formula, if used on sheet 12, will sum up the figures from cell C8 on the current sheet, being sheet12, plus the next 3 sheets, being sheet13, sheet 14 and sheet 15...and so on. Note: Each of my sheets have different names according to the week, i.e. Jan 4-8, Jan 11-15, Jan 18-22, Jan, 25-29, etc. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic Sumning of Same Cell from Different Sheets
EXCEL 2007
Try this:- =SUM(Sheet1:Sheet4!C8) That will sum cells C8 on Sheets 1 to 4 inclusive. If my comments have helped please hit Yes. "Excel Ella" wrote: I'm having difficulty creating a formula that will automatically add the figures in cell C8 on the current sheet, plus the next 3 sheets. I need cell C8 to remain static, but the current sheet and next 3 sheets to change according to whichever sheet I use that formula in. For example, A formula where it sums up the figures from C8 on the current sheet, being sheet1, plus the next 3 sheets, being sheet2, sheet3 and sheet 4...then The same formula, if used on sheet 12, will sum up the figures from cell C8 on the current sheet, being sheet12, plus the next 3 sheets, being sheet13, sheet 14 and sheet 15...and so on. Note: Each of my sheets have different names according to the week, i.e. Jan 4-8, Jan 11-15, Jan 18-22, Jan, 25-29, etc. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic Sumning of Same Cell from Different Sheets
EXCEL 2007
This:- =SUM('Jan 4-8:Jan 25-29'!C8) - will give the correct result too. If my comments have helped please hit Yes. Thanks. "Excel Ella" wrote: I'm having difficulty creating a formula that will automatically add the figures in cell C8 on the current sheet, plus the next 3 sheets. I need cell C8 to remain static, but the current sheet and next 3 sheets to change according to whichever sheet I use that formula in. For example, A formula where it sums up the figures from C8 on the current sheet, being sheet1, plus the next 3 sheets, being sheet2, sheet3 and sheet 4...then The same formula, if used on sheet 12, will sum up the figures from cell C8 on the current sheet, being sheet12, plus the next 3 sheets, being sheet13, sheet 14 and sheet 15...and so on. Note: Each of my sheets have different names according to the week, i.e. Jan 4-8, Jan 11-15, Jan 18-22, Jan, 25-29, etc. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic Sumning of Same Cell from Different Sheets
This is great info! Thank you.
Is there a formula that will automatically change the spreadsheet to the next one in the workbook? "trip_to_tokyo" wrote: EXCEL 2007 This:- =SUM('Jan 4-8:Jan 25-29'!C8) - will give the correct result too. If my comments have helped please hit Yes. Thanks. "Excel Ella" wrote: I'm having difficulty creating a formula that will automatically add the figures in cell C8 on the current sheet, plus the next 3 sheets. I need cell C8 to remain static, but the current sheet and next 3 sheets to change according to whichever sheet I use that formula in. For example, A formula where it sums up the figures from C8 on the current sheet, being sheet1, plus the next 3 sheets, being sheet2, sheet3 and sheet 4...then The same formula, if used on sheet 12, will sum up the figures from cell C8 on the current sheet, being sheet12, plus the next 3 sheets, being sheet13, sheet 14 and sheet 15...and so on. Note: Each of my sheets have different names according to the week, i.e. Jan 4-8, Jan 11-15, Jan 18-22, Jan, 25-29, etc. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Automatic Alpha transfer from other sheets? | Excel Worksheet Functions | |||
Automatic page numbering with multiple sheets in a workbook | Excel Discussion (Misc queries) | |||
Automatic deletion of specific cells from multiple sheets | Excel Worksheet Functions | |||
Automatic comparison and uploading of data among 2 spread sheets | New Users to Excel | |||
Combining different sheets with automatic add in? | Excel Discussion (Misc queries) |