How to Use the Multiple Rows Function in Excel

The multiple rows function in Microsoft Excel accurately counts the number of rows referenced within a section. This reference is also referred to as an "array." Rows can be added or deleted but the count will always remain accurate regardless of these changes as long as the multiple rows formula remains untouched in another independent cell.

Things You'll Need

• A licensed copy of Microsoft Excel 2003 or higher version
• Windows XP or Vista

Instructions

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.

Tips & Warnings

• Use the multiple rows function when row additions and deletion happen often. It can eliminate repetitive counting and recounting. All of the rows within a referenced range will be included whether their cells contain numbers or are empty.