Formula: =SUM(range)
Description: The SUM function adds up the values in a range of cells.
Example:
=SUM(A1:A10)
This formula will add up the values in cells A1 to A10, and return the result.
Usage:
To use the SUM function, simply enter the range of cells that you want to add up into the parentheses of the formula. For example, if you want to add up the values in cells A1 to A10, you would enter the following formula:
=SUM(A1:A10)
You can also use the SUM function to add up the values in multiple ranges of cells. To do this, simply separate the ranges with commas. For example, to add up the values in cells A1 to A10 and B1 to B10, you would enter the following formula:
=SUM(A1:A10, B1:B10)
The SUM function is a very useful function for adding up values in Excel. It can be used in a variety of ways, such as calculating totals, subtotals, and averages.
Here is an example of how to use the SUM function to calculate the total sales for a company in a given month:
=SUM(C2:C10)
This formula will add up the values in cells C2 to C10, which contain the sales figures for each day of the month. The result of the formula will be the total sales for the month.
I hope this tutorial is helpful!