Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for multiple worksheets
I have very basic excel skills but I am trying to create a database. I need
to be able to create a formula using the contents of multiple worksheets. How can this be done? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for multiple worksheets
Hi Greg,
When using other references in formulas, you can simply go and select the required cell while creating the formula in the formula bar and the correct syntax will be filled in for you. Example if you want to sum cell A1 on Sheets 1, 2 and 3 then the formula looks like this:- =SUM(A1,Sheet2!A1,Sheet3!A1) To create it, enter =SUM( Click the first cell then enter a comma then change sheets and Click the next cell and enter a comma and change sheets then Click the last cell and close the brackets and Enter and it's finished. Regards, OssieMac "Greg" wrote: I have very basic excel skills but I am trying to create a database. I need to be able to create a formula using the contents of multiple worksheets. How can this be done? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula with multiple worksheets | Excel Worksheet Functions | |||
Formula with multiple worksheets | New Users to Excel | |||
Formula help for multiple worksheets | Excel Discussion (Misc queries) | |||
Copying a formula to multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |