|
» Summing Values from Cells in Different Sheets
CATEGORY: Summing |
VERSIONS: All Microsoft Excel Versions |
|
In this example, we have a workbook with four successive sheets: January, February, March and April. To total figures from the same cell address in different sheets: 1. Select a cell and type =SUM(. 2. Select the tab for the first sheet, January. 3. Hold the Shift key, and then select the tab for the last sheet, April. 4. Select cell B2, and then press Enter. The formula is now =SUM(January:April!B2). |
| Screenshot // Summing Values from Cells in Different Sheets |
  |
|
RATING:
3.84
VIEWS: 29406 |
||||
Sponsors:
 |
Book Store:
Recommended Books:
Related MS EXCEL TIPS:
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.
