Today we are going to learn about the basic function of the SUM formula. This formula comes in handy when you need to add many cells within a table without having to manually add them yourself.

See below for further details:

SUM

=SUM(value1,value2,value3,...)

Adds all the numbers in a range of cells

In our example we want to add the total amount of sales within the table below:

Here we can see the =SUM function provided the total in the table by sale price.

Our goal is to find the sum, or the total amount of profit made from the sales of all the products. The range we need are cells E3 through E8.

Our formula should look like this:  =SUM(E3:E8)

Thanks for the read! Don’t forget to tip and subscribe for more updates on Excel tips and tricks and more to come.

If you need help with an excel formula, please don’t hesitate to send a private message or comment below.