Hi there,

I am trying to setup a formula using SUMIFS and want the criteria to contain a particular string.
The formula looks like this:

=(SUMIFS('This'!$K$2:$K$75,'This'!$J$2:$J$75,PipelineTeam,'This'!$A$2:$A$75,$A32))

Where PipelineTeam = PIPE in the name manager.

My issue is that I want it to actually match "*PIPE*" which I can type out but I want to ensure I am using named ranges so I can keep things dynamic.

Is this possible?