Roster Template

Tips for using roster templates      How to compile a roster template?
​ 1. A roster of qualified personnel or persons suitable for a particular purpose or service
2. Specifically refers to the roster of officers and soldiers of the army or fleet
3. Personnel roster

General Tips for Roster Templates

​ ​ 1:SUM function (mathematics)
In daily work and study, SUM is an extremely widely used function and can be learned as an entry-level function. Therefore, overall, the SUM function is not difficult but has a wide range of applications. But don’t underestimate SUM just because it is simple. It also has some little-known tricks! 1. Cumulative sum as shown below, which is the sales performance of a certain company every day and requires the calculation of the daily cumulative amount.
For example, enter the formula in cell D2: =SUM(C$2:C2), press the Enter key to complete and fill downwards.
Note: At this time, C$2 must lock the row mark, so that a reference area from the second row to the downward row will be generated during the pull-down process.
​ ​ 2:Sum with qualified cells
The sum of merged cells has always been a troublesome problem for novices.
Select the cell range D2:D13, and then enter the formula in the formula editing bar: =SUM(C2:C13)-SUM(D3:D14), and then press Finish. Note: Be sure to pay attention to the area range of the second SUM function. Misplaced, otherwise an error will be reported.
​ ​ 3: Sum of cells with subtotals
How to sum cells with subtotals? In cell C9, enter the formula: =SUM(C2:C8)/2 and press Enter to complete.
                                                                                                                                                                                                  The process of subtotaling and summing are used here to repeatedly calculate the above data, so dividing by 2 can get a non-repeating result, which is exactly the desired result.