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