adding multiple values together

Hi, i am trying to build a table where i have to add multiple criteria such as "Not Started", "In Progress", "On-Hold", if i use this formula =COUNTIFS({IRM SOW #13 - RAID Log Range 3}, [ARIaDd Type]@row, {IRM SOW #13 - RAID Log Range 1}, "In Progress") it works fine but if i add the search in for the other criteria is seems to zero out the previous calculation, =COUNTIFS({IRM SOW #13 - RAID Log Range 3}, [ARIaDd Type]@row, {IRM SOW #13 - RAID Log Range 1}, "In Progress", {IRM SOW #13 - RAID Log Range 1}, "Not Started")



Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!