Trying to link 2 pages into a formula

[RistinD]

Does anyone know if it is possible to link into a cell the sum of a line of figures? I was trying to press an "=" into the cell that I want the answer in, and then highlight the row I need the sum of (which is on a different sheet) It is returning with a 0 value every time, even though there are values in the fields. Do I absolutely have to create a "sum" field on the original sheet to link into the new sheet, or is there a formula that will add a line up and link into another workbook?

Sorry if this is a dumb question-- I'm kind of an Excel newbie, and mostly just flailing around without a whole lot of success!

 

[HalfAce]

Hi and welcome to the board.
If I understand what you're looking to do then perhaps this will help.
If you wanted (for example) the sum of range A10:E10 on sheet2 to display in a cell on sheet1, you can use a formula like this somewhere on sheet1:

=SUM(Sheet2!A10:E10)

Am I guessing right as to what you asked?

 

[RistinD]

Ahahaha! Yes! That was what I was missing-- an exclaimation point. And parenthesis. Ok, that makes so much more sense- and it works now. Thank you so much for your help!

 

[HalfAce]

Most welcome. Glad it helped.