Sum Apple Values in Excel Using SUMIF or a PivotTable
Question details
Calculate the total amount for rows labeled Apples, either with a formula or a summary table.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The worksheet has product names in one column and corresponding amounts in another column, and the user needs the total for Apples or totals for all products.
- Observed behavior
- The goal is to return the combined value of all amounts whose product name is Apples.
Confirm that the product names and amounts are aligned on the same rows. Remove or correct text entries in the amount column if they should be included as numeric values.
Use SUMIF to total only the Apples rows
Use this method when you need one result for Apples in a cell and your product names and amounts are stored in separate columns.
SUMIF adds values from an amount range only when the matching cell in the criteria range meets your condition. This is the quickest option for a single product total.
Click an empty cell where you want the Apples total to appear, such as D2.
Type =SUMIF(A:A,"Apples",B:B) and press Enter. Replace A:A with the product-name column and B:B with the amount column if your data is arranged differently.
Review the cells in column A labeled Apples; the formula adds the corresponding numeric values from column B.
Create a PivotTable to total every product
Use a PivotTable when you want Apples and all other product totals in one refreshable summary.
Sum Apple Amounts Quickly in WPS Spreadsheets
WPS Spreadsheets lets you use the familiar SUMIF function for an Apple-only total or build a PivotTable to summarize each product in a clear, updateable report.
- 1. Open your worksheet in WPS Spreadsheets: Launch WPS Office, choose Spreadsheets, and open the .xlsx or .xls file containing the product and amount columns.
- 2. Enter the Apple total formula: Select an empty output cell and enter =SUMIF(A:A,"Apples",B:B), adjusting the column references to match your worksheet.
- 3. Build a product summary when needed: Select the data range, go to Insert > PivotTable, and create the PivotTable in a new or existing worksheet.
- 4. Arrange the PivotTable fields: Place Product in Rows and Amount in Values, then confirm that the Values field is summarized by Sum.
Frequently Asked Questions
What does =SUMIF(A:A,"Apples",B:B) do?
It checks column A for cells equal to Apples and adds the corresponding values from column B. The result is the total amount for Apples.
How can I make SUMIF match the word Apples exactly?
Use "Apples" as the criterion, as in =SUMIF(A:A,"Apples",B:B). SUMIF is not case-sensitive, but it does not treat Apple and Apples as the same text.
Why is my PivotTable showing Count instead of Sum for amounts?
Right-click a value in the PivotTable, choose Value Field Settings, and select Sum. Also check that the original amount cells are numbers rather than text.
Can a PivotTable show totals for Apples and other products at the same time?
Yes. Put the product field in the Rows area and the amount field in the Values area. The PivotTable creates one total for each product, including Apples.
Will SUMIF include new Apple entries I add later?
Yes, when you use full-column references such as A:A and B:B. If you use a fixed range, expand the range or convert the data to a table before adding new rows.
