Use the SUM function to sum numbers in a range
You can use a simple formula to sum numbers in a range (a group of cells), but the SUM function is easier to use when you’re working with more than a few numbers. For example =SUM (A2:A6) is less likely to have typing errors than =A2+A3+A4+A5+A6.
SLN function - Microsoft Support
This article describes the formula syntax and usage of the SLN function in Microsoft Excel. Returns the straight-line depreciation of an asset for one period. SLN (cost, salvage, life) The SLN function syntax has the following arguments: Cost Required. The initial cost of …
DB function - Microsoft Support
This article describes the formula syntax and usage of the DB function in Microsoft Excel. Returns the depreciation of an asset for a specified period using the fixed-declining balance method. DB (cost, salvage, life, period, [month]) The DB function syntax has the following arguments: Cost Required. The initial cost of the asset. Salvage Required.