Function Problems

Sum Shelf Quantities by Matching a Name in Excel

Aamir Naveed AkramAamir Naveed Akram Nov 18, 2026 869 views

Question details

Calculate the total quantity for a shelf name by matching names in column B and summing the corresponding values in column E.

Sum Shelf Quantities by Matching a Name in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
A worksheet named Kitchen contains shelf names in column B and quantities in column E.
Observed behavior
The desired result is the sum of quantities in column E for rows whose shelf name in column B matches the specified name.
Before you start

Confirm that shelf names are in Kitchen column B and their corresponding quantities are numeric values in column E. Choose an empty cell outside those columns for the result.

Solution 1Recommended

Use SUMIFS to sum quantities for a matching shelf name

Use this formula when each matching row has a quantity that should be added to the total.

1
Select a result cell

In Excel, select an empty cell outside columns B and E where you want the total to appear.

2
Enter the SUMIFS formula

Type =SUMIFS(Kitchen!E:E,Kitchen!B:B,"uppershelf.bpp") and press Enter. The formula adds values in Kitchen column E where the name in column B matches uppershelf.bpp.

3
Use a cell reference if needed

To change the shelf name without editing the formula, enter the name in A1 on the current sheet and use =SUMIFS(Kitchen!E:E,Kitchen!B:B,A1).

Use SUMIFS to sum quantities for a matching shelf name
SUMIFS versus COUNTIF: SUMIFS adds the matching quantities; COUNTIF counts matching rows instead.
Use WPS Spreadsheets

Sum matching shelf quantities in WPS Spreadsheets

Open your workbook in WPS Spreadsheets and use SUMIFS to total quantities for a shelf name.

  1. 1. Open the workbook: In WPS Office, open WPS Spreadsheets and select Open to choose your Excel workbook.
  2. 2. Select a result cell: Click an empty cell outside columns B and E where you want to display the total.
  3. 3. Enter the formula: Type =SUMIFS(Kitchen!E:E,Kitchen!B:B,"uppershelf.bpp") and press Enter.
  4. 4. Check the result: Compare the total with the quantities in Kitchen column E for rows named uppershelf.bpp in column B.
Sum quantities for a matching shelf name with SUMIFSOpen and edit Microsoft Excel XLSX and XLS filesUse a cell reference to change the shelf name without rewriting the formulaWork with a familiar spreadsheet interface
microsoft office alternative - wps office

Frequently Asked Questions

How do I use a shelf name from a cell instead of typing it into the formula?

Enter the shelf name in A1 on the current sheet, then use =SUMIFS(Kitchen!E:E,Kitchen!B:B,A1).

Why should I use SUMIFS instead of COUNTIF?

SUMIFS adds the quantities in column E for matching names. COUNTIF counts how many cells match the name, regardless of the quantities.

Why is my SUMIFS total zero?

Check that the shelf name matches the entries in Kitchen column B and that the quantities in column E are stored as numbers rather than text.

Does SUMIFS distinguish uppercase and lowercase shelf names?

No. Excel SUMIFS matches text without distinguishing uppercase from lowercase.