I hope you do enjoy this free blog. I only ask one thing from you in return, click in one of the ads

Tuesday, 20 January 2015

SUM function

Category: Mathematical functions

What does this function do?


Returns the sum of a range of cells.



Syntax:


SUM(number1,[number2],...])
  • number1 (required): The first number argument that you want to add.
  • number2 (optional): Number arguments 2 to 255 that you want to add.

Examples:

= SUM (2,3,5) = 10

If A1 = 2, A2 = 3, B3 = 5

= SUM (A1,A2,B3) = 10

No comments:

Post a Comment