ExcelBanter - WildCard Characters

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - WildCard Characters (https://www.excelbanter.com/excel-worksheet-functions/91702-wildcard-characters.html)

Ralph Heidecke

WildCard Characters

is there a way to use a wildcard character in the Sumif expression?

I want to use sumif( range, "ML*", sumrange) where * is the wildcard.

Is there a good web resource on the use of wild card characters?

Toppers

WildCard Characters

As per your own example!

"Ralph Heidecke" wrote:

is there a way to use a wildcard character in the Sumif expression?

I want to use sumif( range, "ML*", sumrange) where * is the wildcard.

Is there a good web resource on the use of wild card characters?

All times are GMT +1. The time now is 05:17 AM.