Using SUMIF with wildcards in Excel

Excel Help for Using Sumif With Wildcards In Excel in Presenting and Reporting Data

Find Excel Solutions

Search Forums:
Recent Activity:
Can't Get It To Give Me The Report I Want
Importing Data From Pdf Files
Need Help With Formulas And Fixing This Spreadsheet
Wanting To Calculate All Hours Worked On A Project With Timesheets
Simple Formulae For Creating Complex Interactive Dashboards In Excel
What Is Microsoft Project Gantt Chart Used For?

Follow Business Spreadsheets On:
Forum TopicReply Login

Using Sumif With Wildcards In Excel

Rate this:
(3/5 from 1 vote)

I've got the following setup of a table:

Excel Spreadsheet:
  A B C D
1  Name Revenue
 Criteria  SUMIF
2  some-text-more (blank-12345)
 2645  blank-12345

What would the formula be if I wanted to make a SUMIF function where it gives the sum of the revenue in column B where the Criteria in column C appears in column A?

 Posted by on
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
Rate this:
(3/5 from 1 vote)
You can use wildcards around the criteria to match partial text in the SUMIF function.

If you have data down 20 rows, the formula in cell D2 is:
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Using SUMIF with wildcards in Excel in the

Find Excel templates
and add-ins in the
Excel Business Solutions Directory
  © 2014 Business Spreadsheets. All Rights Reserved. Legal |