I have a fairly straightforward formula that i cant get to work, driving me crazy! I typically prefer Sumifs over Sumif but currently I am summing a kpi column of numbers if two additional columns (both Text/dropdown (single Select format) report a specific set of words. what am i missing!?! Thanks in advance.
=SUMIFS([KPI Hour Left (Formula)]:[KPI Hour Left (Formula)], [Project Type]:[Project Type], (@cell = "Team - Production", Status:Status, (@cell = "Subscription - Active")))
Help Article Resources
Check out the Formula Handbook template!