| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how to use input formula from several worksheets in excel?
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| formula from multiple worksheets to give a color output to one wo. | Excel Worksheet Functions | |||
| how do i make a cell date sensitive to execute a formula or input. | Excel Discussion (Misc queries) | |||
| How get the rows indicated by one formula to become the input for. | Excel Worksheet Functions | |||
| Help with macro formula and variable | Excel Worksheet Functions | |||
Linear Mode
