When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers. Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you're done. After inserting the desired ranges hit enter and the cell will fill with the function results. If you need to sum a column or row of numbers, let Excel do the math for you.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 |