All you need to do it use the colon sign, ‘:’ from your keyboard between the first cells name and the last cells name on the row or column that you want to add. Look at the example below to understand this format better. =SUM(A1:A6) This is an easier

- [OPTIONAL ] - Additional numbers or ranges to add to value1. Notes. If only a single number for value1 is supplied, SUM returns value1. Although SUM is specified as taking a maximum of 30 arguments, Google Sheets supports an arbitrary number of argument

Adding up rows or columns of numbers is a common operation carried out in all spreadsheet programs. Google Sheets includes a built-in function called SUM for this purpose. With a function in place, the spreadsheet automatically updates when you make chang