Reference a value from 1 sheet in a formula

kbrady13766

Is there a way to reference a specific value from one sheet into a formula on a different sheet.

For example Sheet 1 Row 1 Column 1 has a value of 5

Sheet 2 would like to reference Sheet 1, row 1, column 1 in a simple SUM formula

=SUM(Sheet1:Row1Column1+Sheet2:Row5Column3)

If Sheet 1 Row 1 Column 1 has a value of 5 and Sheet 2 Row 5 Column 3 has a 10 as the value then 5+10=15 would display where the formula was entered on sheet 2

Adam Overton

You can right click on a cell and add a link to a cell in another sheet. Then you can reference that cell in your formula.