Question:

How can I make calculation (add or subt.,,etc numbers) between several books in one XL sheet,,?

by  |  earlier

0 LIKES UnLike

How can I make calculation (add or subt.,,etc numbers) between several books in one XL sheet,,?

 Tags:

   Report

2 ANSWERS


  1. If I am ready the question correctly, you are asking how do you show calculations on one sheet which uses figures from a different sheet.  If so, you can just click the value you need from whichever sheet when you are inputing your formula.  Or, if you want, you could always manually type the reference into the cell.  


  2. To add figures from different books click on the sum icon at the top.

    Click on the first cell you want to add, if needed select the appropiate book / page first (this cell location will appear in the formula bar).

    Hit the + button, click on the next cell to add.

    Repeat as necessary until all cells are done then hit enter / click the tick.

    Done

Question Stats

Latest activity: earlier.
This question has 2 answers.

BECOME A GUIDE

Share your knowledge and help people by answering questions.