Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sheets and formulas
Hi,
I wish to enter formulas in a new worksheet using values from other previously used ones. That is, if I have three different values- for eg.- in one sheet, I wish to have their total in a new sheet using formula(s). In other words, how do I link different sheets together in one document by formulas. Tnx Alex |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sheets and formulas
When writing your formula, you can simply select the cell from the sheet you
want to refer to, or the general format is =SUM('Sheet1'!A1:A10) Where the name of sheet you want to refer to is inside single quotation marks. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Aleksi" wrote: Hi, I wish to enter formulas in a new worksheet using values from other previously used ones. That is, if I have three different values- for eg.- in one sheet, I wish to have their total in a new sheet using formula(s). In other words, how do I link different sheets together in one document by formulas. Tnx Alex |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sheets Names in Formulas | Excel Discussion (Misc queries) | |||
formulas between sheets | Excel Worksheet Functions | |||
Formulas for Time Sheets | Excel Worksheet Functions | |||
Formulas Between Different Sheets | Excel Discussion (Misc queries) | |||
sheets back to formulas | Excel Discussion (Misc queries) |