Monday, September 30, 2019

Excel Basic Functions You Should Definitely know!! (SUM)



The first Excel function you should be familiar with is the one that performs the basic arithmetic operation of addition:
SUM(number1, [number2], …)
In the syntax of all Excel functions, an argument enclosed in [square brackets] is optional, other arguments are required. Meaning, your Sum formula should include at least 1 number, reference to a cell or a range of cells. For example:
=SUM(A2:A6) - adds up values in cells A2 through A6.
=SUM(A2, A6) - adds up values in cells A2 and A6.
=SUM(A2:A6)/5 - adds up values in cells A2 through A6, and then divides the sum by 5.
In your Excel worksheets, the formulas may look something similar to this:



Share:

0 coment�rios:

Post a Comment

Followers

Home Top Ad

Responsive Ads Here

Header Ads

test