0
SUM() is a function within Excel which adds up the values of the cells that are passed to it. You can pass individual cells, a list of cells or a range of cells. e.g.
=SUM(A1) returns the same value as the cell A1
=SUM(A1,B2) return the sum of A1 + B2
=SUM(A1:B2) returns the sum of the range A1:B2
Ranges are effective squares of cells, so the range A1:B2 is a small 2x2 square consisting of A1, A2, B1 and B2.
Wiki User
∙ 14y ago
Wiki User
∙ 14y agoSUM adds a range of numbers.
EXAMPLE:
Find the sum of the contents of cells B1 through B32.
=SUM(B1:B21)
You also can combine several ranges to get a single sum.
=SUM(B1:B12,B34:B42,D13:D43)
Wiki User
∙ 6y agoIf you want to find the sum of a column from A1 to A12, use the following formula:
=SUM(A1:A12)
If you ever want to add 2 or more values (numbers) in excel to get the result in a specified cell, you can use the formula SUM.
Ex: Cell A1 has value 10, Cell B1 has value 20 and Cell C1 has value 30. To get the sum of these three values in cell D1, you can either enter =SUM(A1,B1,C1) or =SUM(A1:C1) in the cell D1.
Wiki User
∙ 8y agoThe purpose of the SUM function in Microsoft Excel is to add values together.
Add your answer:
Earn +20 pts
What following functions was new in Excel 2007 sum ifs sum if count if or sum?
SUMIFS was new in Excel 2007.
What do you use to sum a large range of data in Excel?
The SUM function.
What is the sum of 7 and 4 in Excel spreadsheet?
The sum of 7 and 4 is 11, whether in an Excel spreadsheet or anywhere else. In Excel the formula would be =SUM(4,7) or =4+7 or =(B12+B13) if the values 7 and 4 were in cells B12 and B13.
What is the sign of sum in Excel?
The representation of SUM is the capital Greek letter SIGMA (Σ).
What are some examples of Excel formulas?
formula's of excel =sum(+_/*) =count(if) =today() =now() by' (rubab)
When was Sum ifs introduced to Excel 2007?
The SUMIFS function first appeared in Excel 2007. The previous version, Excel 2003, did not have it.
How do you add 2 values in Excel?
The 'sum' function.Type =sum(X,Y) - bold for emphasis - where X and Y are your cell locations or values, and Excel will return the sum (i.e. the result of addition) of those values.
Can you use Sum Function in school?
If you use Excel in school, then, yes, you can use the SUM function.
Give 5 functions of formulas in Excel?
Built-in formulas in Excel are known as functions. Here are five common ones: SUM AVERAGE COUNT MIN MAX
What is the name of the button you click to sum cells in Excel?
You use the sum button in excel when you want to add numerous amounts of numbers.
What is the keyboard shortcut for the Auto-Sum feature on excel is?
Alt+=
How do you perform a quick-sum in Excel?
Quick-sum in Excel 1. Select the cells you want to sum (Hold CTRL key to select non-adjacent cells) 2. Right click the status bar and select SUM (This is the default option) 3. Now check out the sum of the numbers you selected in the status bar.
