Sum Shelf Quantities by Matching a Name in Excel
Question details
Calculate the total quantity for a shelf name by matching names in column B and summing the corresponding values in column E.

- 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.
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.
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.
In Excel, select an empty cell outside columns B and E where you want the total to appear.
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.
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).

Sum matching shelf quantities in WPS Spreadsheets
Open your workbook in WPS Spreadsheets and use SUMIFS to total quantities for a shelf name.
- 1. Open the workbook: In WPS Office, open WPS Spreadsheets and select Open to choose your Excel workbook.
- 2. Select a result cell: Click an empty cell outside columns B and E where you want to display the total.
- 3. Enter the formula: Type =SUMIFS(Kitchen!E:E,Kitchen!B:B,"uppershelf.bpp") and press Enter.
- 4. Check the result: Compare the total with the quantities in Kitchen column E for rows named uppershelf.bpp in column B.

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.




