In this tutorial, you will learn how to use VLOOKUP to sum multiple rows in Excel.

In a cell of a dataset or table in Microsoft Excel, we occasionally need to search for various types of data pertaining to a particular word or piece of information within the text. The VLOOKUP function makes it simple to locate that word in the table and extract information about the cell value that contains it.

Once ready, we’ll get started by utilizing real-world examples to show you how to use VLOOKUP to sum multiple rows in Excel.

Table of Contents

## Anatomy of VLOOKUP Function

=VLOOKUP(lookup_value, table_array, col_index_number,[range_lookup])

Vertical Lookup is referred to as VLOOKUP. VLOOKUP is a built-in Excel function that, as its name implies, enables you to find a specific value by looking for it vertically across the sheet.

## Use VLOOKUP to Sum Multiple Rows

Before we begin we will need a group of data to use VLOOKUP to sum multiple rows in Excel.

### Step 1

First, you need to have a clean and tidy group of data to work with.

### Step 2

In this example, we want to find the number of stores in New York using the VLOOKUP function. To do so, we need to insert the following formula =SUM(VLOOKUP(A8, $A$2:$D$6, {2,3,4}, FALSE)).

### Step 3

Once you are done, you will be able to use VLOOKUP to sum multiple rows in Excel.