What Excel function is used to calculate a total?

Answer 1

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.

Answer 2

You 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)

Answer 3

It is the same as SUM -- the final result of adding a range of numbers.

Answer 4

The 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.