Using various SUM formats Using SUM( ) The sum function adds values based on a selected range. Example A, shows the total from cells E6 to E9. The syntax is shown as =SUM(E6:E9). You can achieve the same by adding each value individually, like =E6+E7+E8+E9. However, when the list consists of various hundred or thousand…