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.

**#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.

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

## Leave a Reply

You must be logged in to post a comment.