Function Problems

Sum Charges in a Column Using Excel SUMIF

Huda QurayshiHuda Qurayshi Nov 18, 2026 869 views

Question details

The user wants to total amounts in column C for rows where column A contains charge.

How to Sum Charges in a Column Using Excel SUMIF
Product
Microsoft Excel
Device & OS
not provided
Scenario
A worksheet lists transaction descriptions in column A and amounts in column C.
Observed behavior
VLOOKUP returns the first matching result rather than totaling all matching charges.
Before you start

Check that column A contains the transaction labels and column C contains numeric amounts. Identify the first and last data rows so both formula ranges cover the same rows.

Solution 1Recommended

Use SUMIF to total matching charges

Use SUMIF to add all amounts whose corresponding labels contain charge.

1
Select a result cell

Click an empty cell outside the data range where you want the total to appear.

2
Enter the formula

In the formula bar, enter =SUMIF(A2:A100,"*charge*",C2:C100) and press Enter.

3
Adjust the ranges

If your data extends beyond row 100, edit both ranges in the formula bar to include the same rows.

Use SUMIF to total matching charges
Partial and exact matches: The wildcards match charge anywhere in a label, including words such as recharge. For cells that contain only charge, use =SUMIF(A2:A100,"charge",C2:C100).
Sum charges in WPS Spreadsheet

Calculate charge totals in WPS Spreadsheet

Open your workbook in WPS Spreadsheet and use SUMIF to total amounts associated with matching transaction labels.

  1. 1. Open the workbook: Open WPS Spreadsheet, select Open, and choose your Excel workbook.
  2. 2. Choose a result cell: Click an empty cell outside the transaction data.
  3. 3. Enter SUMIF: Enter =SUMIF(A2:A100,"*charge*",C2:C100) in the formula bar and press Enter.
  4. 4. Save the workbook: Select File > Save or Save As to keep the formula in your workbook.
Sum all matching charges with a single SUMIF formulaOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interfaceWork with a free, easy-to-use office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does VLOOKUP repeat the same charge?

VLOOKUP returns the first match it finds for a lookup value. Use =SUMIF(A2:A100,"*charge*",C2:C100) to add the amounts from all matching rows instead.

How do I match only cells that say charge?

Enter =SUMIF(A2:A100,"charge",C2:C100) in an empty cell. This excludes labels with additional text, such as service charge.

Does SUMIF distinguish between uppercase and lowercase?

No. SUMIF is not case-sensitive, so the criterion charge also matches Charge and CHARGE.

Why is my SUMIF result zero?

Check that the labels in column A match your criterion and that the amounts in column C are stored as numbers. Also check in the formula bar that both ranges cover the intended rows.