Issues with multiple Sumifs statements

I can't get this formula to work...any thoughts?


=SUMIFS([Hours/Week]:[Hours/Week],[X Project Status]:[X Project Status], "Active", [Assigned to]:[Assigned to], "Employee Name", Type:Type, <>"Admin") + SUMIFS([Hours/Week]:[Hours/Week],[Y Project Status]:[Y Project Status], "Active", [Assigned to]:[Assigned to], "Employee Name", Type:Type, <>"Admin")

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!