NEW Contains formula

TanyaC

I am trying to use the contains formula within a SUMIF (see below).  This does not seem to work and I can not figure out why.  It seems as though all the examples that are provided, CONTAIN is only used within IF formulas.  Is this the case?

 

My formula:

=SUMIFS({Employee Tasks Range 1}, {Employee Tasks Range 2}, CONTAINS([ResourceName]$1, {Employee Tasks Range 2}), {Employee Tasks Range 3}, >$[Start Date]3, {Employee Tasks Range 3}, <$[End Date]3)

 

My formula in english:

= SUMIFS ({the hours allocated for a task}, {for resources in this column}, CONTAIN (resource name, {for resources in this column}), {and the due date} is greater than Sunday of week x and less then Saturday of week x

 

Paul Newcome

Try replacing the range in your CONTAINS function with @cell.

Jake

Bumping this.  Can't seem to figure out contains!

Paul Newcome

Which parts exactly are you struggling with? CONTAINS is definitely a weird one to get used to.

 

I went ahead and started a new discussion HERE pertaining to this function to hopefully collect some knowledge and ideas about it in one place. Feel free to check it out.