How to calculate sum in Microsoft Excel / How to use SUM function (formula) in Microsoft Excel

SUM

Use of SUM function/formula in Microsoft Excel:

This function in Microsoft Excel add all numbers in selected data cells rang.

Syntax/Formula:

The syntax of SUM function in Microsoft Excel is below.

=SUM(number,[number2], …)

Example:

Step 1: Type number value 25 in cell B5, 36 in cell B6, 95 in cell B7, 15 in cell B8, 95 in cell B9, and 35 in cell B10 as per shown in below image.

Step 2: Type formula =SUM (B5:B10) in cell B12 and press enter.

SUM