How to Use VLOOKUP to Sum Multiple Rows in Excel

VLOOKUP is a powerful function in Excel that allows you to look up data based on a specific value in a table. However, it's not designed to sum multiple rows directly. To sum multiple rows based on a specific criteria in Excel, you can use a combination of SUMIFS, INDEX, and MATCH functions instead. Here's a step-by-step guide on how to use these functions to sum multiple rows in Excel:

Example:

Let's say you have the following data in Excel:

You want to sum the sales for each product.

1. First, create a new table where you want to sum the sales for each product. In this example, create a new table in cells E1:F4:

   Product	Total Sales
   Apple
   Banana
   Orange

2. Click on the cell where you want to display the total sales for the first product (in this example, cell F2).
3. Enter the following formula in the cell:

   =SUMIFS($C$2:$C$7,$B$2:$B$7,E2)

   In this formula, $C$2:$C$7 is the range of sales data, $B$2:$B$7 is the range of product data, and E2 is the cell containing the product name for which you want to calculate the total sales.
4. Press Enter to calculate the total sales for the first product.
5. Copy the formula down to the other cells in the "Total Sales" column.

Now you have the total sales for each product in the new table using the SUMIFS function.