Question

whuch fuction is used to add the value of several cell ?

Answer 1

in which software are you asking that

Answer 2

_______________
Here is your answer
_______________
Microsoft Excel - Formula to Calculate Sum of Cells in Separate Worksheets

This document explains how to calculate the sum or total when working with cell data located in multiple worksheets. 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.

Example using Sheet1 and Sheet2Sheet1 has the following table setup. 

Wisconsin Badgers Football

YearWinsLosses20139320128420111022010111200993200875 (+)

Sheet2 has the following table setup. 

Wisconsin Badgers Football

YearWinsLosses20179320061112005932004102200375200276



WinsLossesTotal

 (+)

Click into the desired cell you wish to add contents and type =SUM( and then the cell range you wish to add. In our example we chose the cell range =SUM(C3:C8).

Note: You are able to add multiple cell ranges by separating them by commas such as(B3:B8,C3:C8).

To add a cell range from a different sheet, simply insert the sheet name with an ! at the end followed by the cell range. In our example we added a range from Sheet2 to Sheet1 with the following function: =SUM(B3:B8, Sheet1!B3:B8)

 (+)

After inserting the desired ranges hit enter and the cell will fill with the function results.
_______________________________
hope this helped
_______________________________