Sumproduct with Wild Card

[davidhall80]

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

 

[pgc01]

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]

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]

Thanks Guys...Much appreciated.

 

[T. Valko]

Thanks Guys...Much appreciated.

You're welcome. Thanks for the feedback!