0
It gets a total of the values in the cells that are selected or values that are listed in the function. It is a very commonly used function as you need to do a lot of adding in a spreadsheet. There are lots of ways of using it. You could use a cell range like this:
=SUM(A2:A10)
You can use individual cells:
=SUM(A2, A12, A14,B10)
You can use actual values:
=SUM(10,34,20)
You can use it mixing any of those:
=SUM(23,A3:A65,C10,D40)
Wiki User
∙ 14y ago
Wiki User
∙ 7y agoIt will sum up the figures in your pivot table, giving totals for the different categories of data, depending on how the pivot table is set up and what it contains. So for example, if it was analysing sales made by different salesmen in different regions you could get the sum of sales made in each region and the sum of sales made by each salesman.
Add your answer:
Earn +20 pts
Can you enter a function in Excel using autocomplete?
You can use the clipboard in Excel. It is a facility as opposed to a traditional function, like the SUM function or AVERAGE or MAX and other functions that are built in to Excel.
What following functions was new in Excel 2007 sum ifs sum if count if or sum?
SUMIFS was new in Excel 2007.
How do you calculate amount of data transfer?
If you are using Microsoft Word Excel then you could just use the Auto Sum.
How do you produce the sum of a column by using the auto sum function?
Assuming you're using Microsoft Excel, select the entire column by clicking and dragging with the mouse, then press the AutoSum button (looks like Σ).
What do you use to sum a large range of data in Excel?
The SUM function.
What is top function in Excel?
If by the top function, you mean the most commonly used one, that is probably 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.
How do you do math in excel?
You type an equals sign into the formula box, type in the sum you want to do using the cell references (coordinates) then click enter
How do you add the total or a column full of numbers without using a calculator?
Since you put this question in the Excel category, I will answer relative to what you can do with Excel. The quick way is to highlight the column of numbers and click on the Auto-Sum button.
What is the sign of sum in Excel?
The representation of SUM is the capital Greek letter SIGMA (Σ).
Which function divides the sum total by the number of values?
To divide the sum of a data set by the number of values is called the "mean" function of the data set. It is called the AVERAGE function in Excel.
What are some examples of Excel formulas?
formula's of excel =sum(+_/*) =count(if) =today() =now() by' (rubab)
