Excel Formulas: SUM

Excel Formulas: SUM

By MetaCryptoHunter | Excel Guides | 23 Jun 2020


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:

116d2fef621f5646ee81175a46cf1ddc674c2850e3fdcb52f534982f5a23f7aa.png

 

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.

How do you rate this article?


0

0

MetaCryptoHunter
MetaCryptoHunter

Excel Guru Crypto Enthusiast


Excel Guides
Excel Guides

Basic to intermediate how-to guides on everything from shortcuts to formulas and design theory for easy to read eye catching reports!

Send a $0.01 microtip in crypto to the author, and earn yourself as you read!

20% to author / 80% to me.
We pay the tips from our rewards pool.