{"id":92,"date":"2019-04-02T11:12:56","date_gmt":"2019-04-02T08:12:56","guid":{"rendered":"https:\/\/www.test4u.eu\/excelpedia\/?p=92"},"modified":"2019-04-04T16:21:32","modified_gmt":"2019-04-04T13:21:32","slug":"the-sum-function","status":"publish","type":"post","link":"https:\/\/www.test4u.eu\/excelpedia\/the-sum-function\/","title":{"rendered":"The SUM function"},"content":{"rendered":"\n

One of the most used functions in Excel is the SUM <\/strong>function. It is used to calculate the sum of a cell range and can be used by itself or in combination with other functions boosting their potential.<\/p>\n\n\n\n

Its syntax is pretty straightforward:<\/p>\n\n\n\n

SUM(n1,[n2],…)<\/strong><\/p>
n1, n2, …<\/strong> : They are the values you want to add.
n2, …<\/strong> : Optional arguments that can be up to a maximum of 255 <\/cite><\/blockquote>\n\n\n\n

<\/p>\n\n\n\n

These values can be:<\/p>\n\n\n\n
numbers<\/strong><\/td>=SUM(1, 3)<\/td><\/tr>
cell references<\/strong><\/td>=SUM(A6, B5)<\/td><\/tr>
cell ranges<\/strong><\/td>=SUM(A2:A9, G5:G6)<\/td><\/tr>
named ranges<\/strong><\/td>=SUM(myRange1, myRange2)<\/td><\/tr>
combination of the above<\/strong><\/td>=SUM(A6, 2, F4:F7, myRange1)<\/td><\/tr><\/tbody><\/table>\n\n\n\n

<\/p>\n\n\n\n\n

<\/div>\n\n\n\n

Click on the button to practice using this function, with the help of our Online Assessment Tool<\/strong>:<\/p>\n\n\n

Practice<\/a><\/p>\n\n\n\n

<\/div>\n\n\n\n\n

Here are some examples of all the possible uses of SUM:<\/strong><\/p>\n\n\n\n

<\/p>\n\n\n\n

Navigate to the cell H17 <\/strong>of the active worksheet and use the appropriate function to display the total of the cell range H6:H9<\/strong>. <\/p>\n\n\n\n

\n