In our example we added a range from Sheet2 to Sheet1 with the following function: =SUM(B3:B8, Sheet1!B3:B8) To add a cell range from a different sheet, simply insert the sheet name with an ! at the end followed by the cell range.Note: You are able to add multiple cell ranges by separating them by commas such as(B3:B8, C3:C8). In our example we chose the cell range =SUM(C3:C8). Click into the desired cell you wish to add contents and type =SUM( and then the cell range you wish to add.In other words, how to take the value of a cell located in one worksheet and add it to the value of another cell located in another worksheet to come up with the total of the respective cells. This document explains how to calculate the sum or total when working with cell data located in multiple worksheets.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |