Using SUMIF with wildcards in Excel

Excel Help for Using SUMIF with wildcards in Excel in Presenting and Reporting Data

Find Excel Solutions

Search the Forums:
	Search
Recent Activity:
Delete Cell Items In Spreadsheet
Importing Data From Pdf Files
New Portfolio Optimization Template Version
Financial Market Data Feed
Run Time Error 1004
Data Downloader Crashes Excel

Follow Business Spreadsheets On:

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

Forum Topic

Reply Login

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

Find Excel templates
and add-ins in the
Excel Business Solutions Directory