Wildcard to only return specific value

**thomasuponor** · 10-29-2020, 03:48 AM

Hello,

Using wildcard, I would want to only sum the values with "ring". Using "*ring*" it also returns string. I am currently trying with "*"&Ring&"*" but it does not work.
Formula being used:

Please Login or Register  to view this content.

A-UFH	1005263	MINITEC RING NATURAL	Radiant Heating & Cooling	143
A-UFH	1005264	MINITEC COUPLING, RING	Radiant Heating & Cooling	140
A-UFH	1005265	MINITEC ADAPTER MALE THREAD, RING	Radiant Heating & Cooling	130
A-UFH	1034554	MULTI BEND SUPPORT STRING PLASTIC	Radiant Heating & Cooling	777
A-UFH	1034555	MULTI BEND SUPPORT STRING PLASTIC	Radiant Heating & Cooling	670

**Pepe Le Mokko** · 10-29-2020, 03:51 AM

Please post a sample sheet ( see yellow banner). thanks

**Glenn Kennedy** · 10-29-2020, 03:56 AM

Maybe use a space before RING, ie what's inside the parentheses: ( RING&"*")

**thomasuponor** · 10-29-2020, 03:56 AM

Thanks. Please see attached.

**thomasuponor** · 10-29-2020, 03:58 AM

Hi Glenn, thanks for replying. That didn't work.

**Glenn Kennedy** · 10-29-2020, 04:02 AM

Like this:

=SUMIFS(E:E,A:A,"A-UFH",D:D,"Radiant Heating & Cooling",'Sales data'!C:C,"*"&" Ring"&"*")

you'll need ; instead of ,

**AliGW** · 10-29-2020, 04:04 AM

Try this:

=SUMIFS(F:F,B:B,"A-UFH",E:E,"Radiant Heating & Cooling",D:D,"* Ring*")

**thomasuponor** · 10-29-2020, 04:07 AM

That did the job! thanks a lot

**Glenn Kennedy** · 10-29-2020, 04:07 AM

Hahaha. That didn't work for me, first time round... I must have fouled up somewhere....

**AliGW** · 10-29-2020, 04:09 AM

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

**thomasuponor** · 10-29-2020, 04:21 AM

That also did the job. Perfect. Cheers.

Wildcard to only return specific value

LinkBack

Thread Tools

Rate This Thread

Display

Wildcard to only return specific value

Re: Wildcard to only return specific value

Re: Wildcard to only return specific value

Re: Wildcard to only return specific value

Re: Wildcard to only return specific value

Re: Wildcard to only return specific value

Re: Wildcard to only return specific value

Re: Wildcard to only return specific value

Re: Wildcard to only return specific value

Re: Wildcard to only return specific value

Re: Wildcard to only return specific value

Thread Information

Users Browsing this Thread

Similar Threads

Wildcard search and return multiple rows

Autofilter number with wildcard return blank value

Formula to lookup a wildcard value and return a value if true

[SOLVED] Wildcard vlookup return multiple values

Find Wildcard, return that Wildcard value?

[SOLVED] If text does not contain (wildcard), return value of cell

[SOLVED] Wildcard Query to return certain criteria

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions