✭✭✭✭

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")

• ✭✭✭✭✭✭

That is because the COUNTIFS function basically uses an AND function on the back-end. Your above formula is basically saying to count where the cell equals "In Progress" and "Not Started" at the same time which is not possible. You are going to need to incorporate an OR function like so:

=COUNTIFS({IRM SOW #13 - RAID Log Range 3}, [ARIaDd Type]@row, {IRM SOW #13 - RAID Log Range 1}, OR(@cell = "In Progress", @cell = "Not Started"))

• ✭✭✭✭✭✭

That is because the COUNTIFS function basically uses an AND function on the back-end. Your above formula is basically saying to count where the cell equals "In Progress" and "Not Started" at the same time which is not possible. You are going to need to incorporate an OR function like so:

=COUNTIFS({IRM SOW #13 - RAID Log Range 3}, [ARIaDd Type]@row, {IRM SOW #13 - RAID Log Range 1}, OR(@cell = "In Progress", @cell = "Not Started"))

• ✭✭✭✭

This was great, many thanks it worked first time 😁

• ✭✭✭✭✭✭

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!