how to use input formula from several worksheets in excel?

M

Mona

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.
 
R

Rowan

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)
 
Top