Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Multi-criteria lookup and transpose in Excel
  • How to use Excel FORMULATEXT function
  • How to retrieve first match between two ranges in Excel
  • How to get address of last cell in range in Excel
  • How to get address of named range in Excel

Data Analysis Examples

  • Randomize/ Shuffle List in Excel
  • Reverse List in Excel
  • Use Data Form to input, edit and delete records in Excel
  • Error Bars in Excel
  • How to sum a total in multiple Excel tables

Data Validation Examples

  • Excel Data validation specific characters only
  • Excel Data validation unique values only
  • Excel Data validation must not contain
  • Excel Data validation only dates between
  • Excel Data validation no punctuation

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:

Worked Example:   Sum if less than in Excel
=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”.

Worked Example:   SUMIFS function: Description, Usage, Syntax, Examples and Explanation

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 (“”).

Worked Example:   Subtotal by invoice number in Excel

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:

Sum if cells contain specific text in Excel

Next Post:

Sum if between 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
  • How to find nth occurrence of character in Excel
  • How to convert text string to array in Excel
  • Manipulating text strings using Left, Mid, Right, Len, Substitute in Excel
  • RIGHT, RIGHTB functions: Description, Usage, Syntax, Examples and Explanation
  • How to extract domain from email address in Excel
  • Dynamic date list in Excel
  • Add decimal hours to time in Excel
  • Get days before a date in Excel
  • Create date range from two dates in Excel
  • Display Date is same month in Excel
  • Calculate periods for annuity in Excel
  • FVSCHEDULE function: Description, Usage, Syntax, Examples and Explanation
  • DURATION function: Description, Usage, Syntax, Examples and Explanation
  • Calculate interest rate for loan in Excel
  • INTRATE function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2022 xlsoffice . All Right Reserved. | Teal Smiles