View Single Post
  #2   Report Post  
Rowan
 
Posts: n/a
Default

If the sheets are all in the same format and you want to sum cell A1
from each sheet then maybe:

=SUM(Sheet1:Sheet12!A1)

Mona wrote:
I am working from 13 worksheets in excel. the 13th worksheet needs to have a
formula which uses the numbers from the other 12 worksheets. i do not know
which one i could use? Can anyone help.