What is wrong with this formula? =SUMIFS({(Template) Channel Monthly Plan Range 1}, {(Template) Channel Monthly Plan Range 1}, >0, {(Template) Channel Monthly Plan Range 4}, >=DATE(2021, 2, 1), {(Template) Channel Monthly Plan Range 4}, <=DATE(2021, 2, 28), CONTAINS('"Victoria Scholly",{(Template) Channel Monthly Plan Range 6}))
All ranges are pulled in from another sheet. Main objective is to calculate the total Est. hours that are within February and are assigned to Victoria. The issue here is sometimes in the owner column two owners are assigned to the same cell which using my old formula - =SUMIFS({(Template) Channel Monthly Plan Range 1}, {(Template) Channel Monthly Plan Range 1}, >0, {(Template) Channel Monthly Plan Range 6}, "Victoria Scholly", {(Template) Channel Monthly Plan Range 4}, >=DATE(2021, 2, 1), {(Template) Channel Monthly Plan Range 4}, <=DATE(2021, 2, 28)) - would not pull in the hours if someone else was assigned in that column. So I figured a "contains" might work, but it is not.
(Template) Channel Monthly Plan Range 1 = Est. Hours
(Template) Channel Monthly Plan Range 4 = Due Date
(Template) Channel Monthly Plan Range 6 = Owner (Contact List)
