Adding up values from separate tabs
 

Hi,
I have 1 tab, called 'Annual stats',within which there are 9 cells which
need formulas to add the values from the other 52 tabs (weeks). Each tab for
the weeks are the same, so cell E30 is for example one cell which I need to
be added. The tabs are labelled 'Week1' 'Week2' etc.

What formula could i use?

Adding up values from separate tabs
 

Try this:

=SUM(Week1:Week52!E30)

will add all the E30 cells on the sheets which are physically in
between Week1 and Week52 tabs.

Hope this helps.

Pete

On Mar 31, 3:02*pm, DaveAsh wrote:
Hi,
I have 1 tab, called 'Annual stats',within which there are 9 cells which
need formulas to add the values from the other 52 tabs (weeks). Each tab for
the weeks are the same, so cell E30 is for example one cell which I need to
be added. The tabs are labelled 'Week1' 'Week2' etc.

What formula could i use?

Adding up values from separate tabs
 

Hi,

Try this

=SUM(Week1:Week52!A1)

Which will sume A1 in all your sheets

Mike

"DaveAsh" wrote:

Hi,
I have 1 tab, called 'Annual stats',within which there are 9 cells which
need formulas to add the values from the other 52 tabs (weeks). Each tab for
the weeks are the same, so cell E30 is for example one cell which I need to
be added. The tabs are labelled 'Week1' 'Week2' etc.

What formula could i use?