Quick Analysis is the name given to the icon that appears after making a selection in your spreadsheet. The sum of all columns is instantly calculated and added to the row below the selected range. Same trick for rows Now, if you want to sum all the cells of the same row, the technique is the same. The result is as follows.