Home > Forum Home > Presenting and Reporting Data > Using SUMIF with wildcards in Excel Share

Using SUMIF with wildcards in Excel

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


Forum TopicPost Reply 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