SUM

Definition: The SUM function in Excel is used to find the sum of a range of data.

Syntax: ==SUM(number1, [number2], …).

Situation: This formula is appropriate in situations where you need to find the sum of a range of data.

Example: If you have a range of data A1:A10, you would use the formula =SUM(A1:A10). This would return the sum of the data in the range.