How to AutoSum Multiple Rows and Columns in Excel

This post will guide you how to AutoSum function to sum multiple rows and columns quickly in Excel.

AutoSum Multiple Rows and Columns

Assuming that you have a list of data in range:A1:C5, in which contain numeric values. And you want to sum those numbers at once. How to do it. You can use the AutoSum feature to calculate the sum values of those numbers in range A1:C5 quickly. Just do the following steps:


#1 select the range of cells in which you want to calculate the sum values.

autosum multiple rows1M

#2 go to FORMULAS tab, click AutoSum command under Function Library group.  Or you can go to HOME tab, click AutoSUM button under Editing group.

autosum multiple rows2

autosum multiple rows3

autosum multiple rows4

autosum multiple rows5

You would notice that the sum values are calculated and appear in the last row and in the last column of the selected range.