Sum function in excel is an inbuilt function which is used to aggregate value from a selection of columns or rows from your selected range.Most of the times you’ll use the SUM function to sum a range of cells.
Sum Formula in Excel:
The formula
for the SUM function is as follows:
AutoSum:
Use AutoSum
or press ALT+= to quick sum or row numbers
How to use the SUM Function in Excel?
Example 1:
Most of the
time we will use SUM function in excel to Sum a range of Cells. In the below
format we can see in Column D contains half-yearly sale vales; here we are
taking first and last cell in a range of cells to added up. We need to select a
range from cell D4 to D9, i.e. =SUM(D4:D9)
Example 2:
We can do a
sum of entire column also. In the below format we have a town in the column A
and sale of Feb in column B. If we want to calculate entire Feb cell then we
use the formula as below. i.e. =SUM(B:B)
Example 3:
In this
example we can see that Sum function is using to sum non-contagious cell by
using Comma (,). If we want to adding sale of Jan, Mar and June then we need to
take the cell of D4, D6, and D9 and the formula will be SUM(D4,D6,D9). In the
below format if we need to calculate some selective cell then below formula is
working.
Example 4:
In this
example if we want to sum function for fraction value “10/5”,”8/2”, “6/3”
&”12/4” then the formula will be SUM (10/5,8/2,6/3,12/4)
The Sum
function return value is 11
Example 5:
In the previous
examples we have added only one range one time but in the below example we will
add up multiple range of cells.
D2:D5
represents Jan Sale
E2:E5 represents Feb Sale
F2:F5 represents Mar sale
If we want 1stQtr
Sale, then we need to sum up sale of D2 to F5. The formula will be
=SUM(D2:D5,E2:E5,F2:F5)
We can use another formula to add this range. i.e. =SUM(D3:F3)
Good work
ReplyDeleteExcellent
ReplyDelete