Automatic Sumning of Same Cell from Different Sheets
in [Functions]
|
Prev: Trying to calculate # of times text string is displayed
Next: How do I find the minimum value in a range while ignoring zeros?
From: Excel Ella on 5 Apr 2010 20:26 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.
From: trip_to_tokyo on 6 Apr 2010 00:12 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.
From: trip_to_tokyo on 6 Apr 2010 00:15 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.
From: Excel Ella on 8 Apr 2010 18:36
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. |