adding and subtracting two formulas in excel

[TexasMunky]

I'm trying to add the value of two separate functions in Excel, and have the sum placed into a different cell on a different page in the same spreadsheet. I need help on how exactly to do this. Thanks in advance.

 

[etaf]

can you give an example spreadsheet

if function 1 is in sheet 1 cell A1
and function 2 is in sheet 1 cell A2
and the result in sheet2 cell B1

In sheet2 cell B1

=Sheet1!A1 + Sheet1!A2

will add those two cells in sheet 1 together and the result will be in sheet2

but i suspect you dont mean that

 

[TexasMunky]

One cell has the result of a function. So do all the others. I need to take those results and add them all up into another cell on a different page.

 

[etaf]

so does my example not work ?

 

[Lucky09]

If you're trying to get the sum of more than 2 cells, Select the cell where you want to get the answer then command =Sum(Select all the cells that you want to add up)