adding multiple values together

ShaunW

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

Paul Newcome

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

Paul Newcome

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

ShaunW

This was great, many thanks it worked first time 😁

Paul Newcome

Happy to help. 👍️