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:
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?
Check Pdf Files For Text From Excel File.




Follow Business Spreadsheets On:
 
Forum TopicReply Login

Using Sumif With Wildcards In Excel

Rate this:
(3/5 from 1 vote)
ConfusedHi,

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?

Thanx!
Stefan
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
Happy
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:
=SUMIF(A2:A20,"*"&C2&"*",B2:B20)
 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 |