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:
Vba Save To Skydrive
Auto-timing Not Working Properly
"runtime Error 13" And "runtime Error -2147483640" Excel 2011 Mac
Portfolio Performance Monitoring And Valuation
Importing Data From Pdf Files
Help Required From Administrator

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 |