How to Use the Multiple Rows Function in Excel

1.
In Excel, place your cursor in an empty cell located below the group of numbers that you would like to reference.
2.
Click on the 'Function' key located to the left of the Formula task bar.
3. Select 'Rows' from the Function list.
4. Click 'OK'.
5.
Highlight the section of rows containing the set of numbers you would like to add or enter the row and column reference points in the Formula bar.
6.
Click 'OK' to exit.
7.
Test the formula's accuracy by adding a couple of new rows. Highlight two rows within the middle of the range. To do this, left-click your mouse and hold down the 'Down-Arrow Key.' Release. The rows should still be highlighted.
8.
Right-click your mouse, then select 'Insert.'
9.
Verify that the cell containing the formula references all of the rows including the new row additions you just made.