Computer Applications

Explain the following function:

SUM ( )

Spreadsheet

64 Likes

Answer

This function calculates the total of all the values of the specified cells and returns the result to the cell where the cell pointer is located.

Its syntax is:
=SUM(number1, number2, …….) where argument type is Number and return type is Number.

To find the sum of the cell values ranging from A1, A2, A3, …….. to An, the function will be written as:
=SUM(A1, A2, A3, ……., An)
      OR
=SUM(A1:An)

Answered By

34 Likes


Related Questions