Sum Everthing Except...


I would like to use the formula below but add another condition to it. I have an additional column named "Site Name". Is there any way to include everything in the Site Name column except Site Name "Unassigned"?

=SUMIFS([Techs Assinged]:[Techs Assinged], [Project Status]:[Project Status], "In Progress")

The above formula counts all Technicians Assigned. I would like the new formula to exclude the technicians that are Unassigned.

Thank you in advance!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!