Formula for multiple worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top