# Sumproduct with Wild Card

#### davidhall80

##### Well-known Member
Does anyone know how to do a sumproduct with consideration to a wildcard. This is what I am tring to do:

SUMPRODUCT(--(D14:D25="Yes"),--(E14:E25="*New*"),F14:F25)

Any help would be greatly appreciated. Thanks

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

#### pgc01

##### MrExcel MVP
Hi David

Try:

=SUMPRODUCT(--(D14:D25="Yes"),--ISNUMBER(FIND("New",E14:E25)),F14:F25)

Remark: the formula is case sensitive. If you prefer it case insensitive replace Find() with Search()

#### T. Valko

##### Well-known Member
Does anyone know how to do a sumproduct with consideration to a wildcard. This is what I am tring to do:

SUMPRODUCT(--(D14:D25="Yes"),--(E14:E25="*New*"),F14:F25)

Any help would be greatly appreciated. Thanks
If you're using Excel 2007 or later...

Use cells to hold the criteria:

• A14 = yes
• B14 = new
Then:

=SUMIFS(F14:F25,D14:D25,A14,E14:E25,"*"&B14&"*")

#### davidhall80

##### Well-known Member
Thanks Guys...Much appreciated.

#### T. Valko

##### Well-known Member
Thanks Guys...Much appreciated.
You're welcome. Thanks for the feedback!

Replies
1
Views
95
Replies
3
Views
715
Replies
0
Views
241
Replies
0
Views
250
Replies
5
Views
242

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,163,951
Messages
5,834,550
Members
430,295
Latest member
amdis

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back