Sum Charges in a Column Using Excel SUMIF
Question details
The user wants to total amounts in column C for rows where column A contains charge.

- 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.
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.
Use SUMIF to total matching charges
Use SUMIF to add all amounts whose corresponding labels contain charge.
Click an empty cell outside the data range where you want the total to appear.
In the formula bar, enter =SUMIF(A2:A100,"*charge*",C2:C100) and press Enter.
If your data extends beyond row 100, edit both ranges in the formula bar to include the same rows.

Calculate charge totals in WPS Spreadsheet
Open your workbook in WPS Spreadsheet and use SUMIF to total amounts associated with matching transaction labels.
- 1. Open the workbook: Open WPS Spreadsheet, select Open, and choose your Excel workbook.
- 2. Choose a result cell: Click an empty cell outside the transaction data.
- 3. Enter SUMIF: Enter =SUMIF(A2:A100,"*charge*",C2:C100) in the formula bar and press Enter.
- 4. Save the workbook: Select File > Save or Save As to keep the formula in your workbook.

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.




