NEW Contains formula
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
Comments
-
Try replacing the range in your CONTAINS function with @cell.
-
Bumping this. Can't seem to figure out contains!
-
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.
Help Article Resources
Categories
Check out the Formula Handbook template!