help with formula

[themole]

i'm trying to find a way to set up a formula to calulate the values of the exact same cell on each different tab in my spreadsheet.

i have different tabs for each individual weeks and a seperate tab for 'year to date' figures.

what i'm after is a way to calculate the values of the same cell instead of going through each tab, selecting each cell and having an enormous formula for each cell.

much appreciated,

Steve

 

[T. Valko]

i'm trying to find a way to set up a formula to calulate the values of the exact same cell on each different tab in my spreadsheet.

i have different tabs for each individual weeks and a seperate tab for 'year to date' figures.

what i'm after is a way to calculate the values of the same cell instead of going through each tab, selecting each cell and having an enormous formula for each cell.

much appreciated,

Steve

Well, it depends on what kind of calculation you're doing.

Can you provide more specific details?

 

[pagrender]

If you are trying to sum the same cells of all the sheets, you can use this formula:
=SUM(Sheet1:Sheet3!A1)

This will Sum cells A1 from Sheet 1, Sheet 2, and Sheet 3.

A quick way to get your formula to look like this is to Group your sheets.

 

[themole]

cheers Pagrenda, absolute spot on there,

thanks very much, really apprecited