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.

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.

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.

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.