| Home > Forum Home > Presenting and Reporting Data > Using SUMIF with wildcards in Excel > Use wildcards on the criteria | Share |
Use wildcards on the criteria
Excel Help for Use Wildcards On The Criteria in Presenting and Reporting Data
| Forum Topic | Login |
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 | ||
| View Full Post |
| Find relevant Excel templates and add-ins for Use wildcards on the criteria in the Excel Business Solutions Directory |