Summary The SUM function helping us to add individual values, selected range or mix of them including selected individual cells. Will learn with multiple examples: Sr. No. Function Type Action Result Remark 1 Single Column =SUM(F2:F16) 68995 The function adds the values available in between and including F2 to F16. 2 Single Row =SUM(E17:F17) 2293445 The function adds the values available in between and including E17 to F17. 3 Multiple Columns =SUM(E2:E16,F2:F16) 2293445 The function adds the values available in between and including E2 to E16 and F2 to F16. 4 Multiple Rows =SUM(E2:F2,E3:F3) 4125 The function adds the values available in between and including E2 to F2 and F2 to F3. Purpose T...