SUM() Formula in Excel

The SUM() formula in Excel is one of the simplest and most used formulas available.

The SUM() formula shows the total of the selected range of cell values. It simply adds up all the values in the selected range. See the example below.

sum function in Excel

As you can see above, to find the total amount of sales for all months, we simply type in the function

=SUM(B2:B7)

This automatically adds up each of the values of the monthly sales for us i.e.

£1,000
£2,000
£1,500
£3,000
£2,500
£2,500

=£12,500

The result is stored in B8. 

Ian Jamieson avatar

Leave a Reply

Your email address will not be published. Required fields are marked *