Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Use Data Form to input, edit and delete records in Excel
  • Create Scatter Chart in Excel
  • How To Load Analysis ToolPak in Excel
  • How to conditionally sum numeric data in an Excel table using SUMIFS
  • What-If Analysis: Scenarios and Goal Seek in Excel

References

  • How to get relative column numbers in a range in Excel
  • Count rows that contain specific values in Excel
  • How to calculate two-way lookup VLOOKUP in Excel Table
  • How to use Excel VLOOKUP Function
  • How to get first column number in range in Excel

Data Validations

  • Excel Data validation don’t exceed total
  • Excel Data validation must contain specific text
  • Excel Data validation must begin with
  • Excel Data validation whole percentage only
  • How To Create Drop-down List in Excel

Sum if begins with in Excel

by

This tutorial shows how to Sum if begins with in Excel using the example below;

Formula

=SUMIF(range,"text*",sum_range)

Explanation

To sum cells if other cells begin with a specific value, you can use the SUMIF function.

In the example shown, cell G6 contains this formula:

=SUMIF(C5:C11,"t-shirt*",D5:D11)

This formula sums the amounts in column D when a value in column C begins with “t-shirt”. Note that SUMIF is not case-sensitive.

How the formula works

The SUMIF function supports wildcards. An asterisk (*) means “one or more characters”, while a question mark (?) means “any one character”.

These wildcards allow you to create criteria such as “begins with”, “ends with”, “contains 3 characters” and so on.

To match all items that begin with “T-shirt”, the criteria is “t-shirt*”. Note that you must enclose literal text and the wildcard in double quotes (“”).

Alternative with SUMIFS

You can also use the SUMIFS function to sum if cells begin with. SUMIFS can handle multiple criteria, and the order of the arguments is different from SUMIF. The equivalent SUMIFS formula is:

=SUMIFS(D5:D11,C5:C11,"t-shirt*")

Notice that the sum range always comes first in the SUMIFS function.

Post navigation

Previous Post:

How to use Excel CHOOSE Function

Next Post:

Customize Ribbon In Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • SWITCH function: Description, Usage, Syntax, Examples and Explanation
  • IF, AND, OR and NOT Functions Examples in Excel
  • How to use IFS function in Excel
  • Not Equal To ‘<>‘ operator in Excel
  • FALSE function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • YEAR function: Description, Usage, Syntax, Examples and Explanation
  • Convert Excel time to decimal seconds
  • Get first Monday before any date in Excel
  • NETWORKDAYS function: Description, Usage, Syntax, Examples and Explanation
  • How to get workdays between dates in Excel

Grouping

  • Group times into unequal buckets in Excel
  • Calculate conditional mode with criteria in Excel
  • How to randomly assign people to groups in Excel
  • Group numbers with VLOOKUP in Excel
  • Group times into 3 hour buckets in Excel

General

  • How to password protect excel sheet?
  • Excel Autofill Cell Ranges, Copy, Paste
  • 3D SUMIF for multiple worksheets in Excel
  • 44 Practical Excel IF function Examples
  • Subtotal by color in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning