0
There is no function called TOTAL in Excel. You can get totals using several functions, most commonly the SUM function. There is a function called SUBTOTAL which allows you to do different types of standard calculations, including getting totals, averages, highest numbers, lowest numbers and some other things.
Wiki User
∙ 6y ago
Wiki User
∙ 11y agoYou would use the SUM function. For example, if you wanted to total the values in the cells from A2 to A12, you could use the SUM function as follows.
=SUM(A2:A12)
Although it would be rarely used, you could also use the SUBTOTAL function as follows, where the 9 is telling it to do a sum, as it is capable of doing other activities too:
=SUBTOTAL(9,A2:A12)
Wiki User
∙ 14y agoIt is the same as SUM -- the final result of adding a range of numbers.
Wiki User
∙ 11y agoThe SUM function is the main function used to calculate a total. It can also be done with SUBTOTAL, and it is possible with SUMIF, SUMIFS and DSUM.
Add your answer:
Earn +20 pts
Which excel function would be used to calculate the total points a student earned ona aseries of tests?
The SUM function.
Which Excel function would be used to calculate the total points a student earned on a series of tests?
sum
What formula is used to calculate quantity?
You can calculate quantity in Excel with the SUM function.
What Excel function can be used to calculate the futue value of any investment?
The FV function.
What function is used to total table values that meet a specified criteria in Excel?
The SUMIF function.
How do you calculate interst rates on Mircosoft Excel 2003?
It depends on what you are trying to calculate, like interest on investments or loans for example. The INTRATE function and the RATE function can be used. There are other specialised financial functions too.
What is the status bar command used to obtain total and average numbers in a range in excel?
auto calculate area
What function calculates the budget on Excel?
The SUM function would be used to total up the figures for the budget, but other functions might be used too during the process.
What formulas can be used to correctly calculate your annual loan payments to Aunt Tillie for the car loan?
Use PMT function in the excel sheet.
What Excel function can be used to calculate the mean of a range of cells.?
The Average function. For example, to get the mean of the cells from A2 to A15, you would use it this way: =AVERAGE(A2:A15)
Values used with a function in Excel?
Arguments
The function is the most frequently used type of function formula?
The SUM function would be the most commonly used function in Excel.
