Using SUMIF with wildcards in Excel

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

Forum Topic

Using Sumif With Wildcards In Excel

Rate this:

(3/5 from 1 vote)

Hi,

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 scallebaut on 20 Apr 2011

Replies - Displaying 1 to 1 of 1

Order Replies By: Most Recent | Chronological | Highest Rated

	Use wildcards on the criteria 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 Excel Helper on 20 Apr 2011

Displaying page 1 of 1

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