=" " multiples values

Corporate Corporate

how would I enter a formula to count multiple values like ="closed" + "solved" + .... It this even possible, cannot find anything on learning center

Paul Newcome

You would need to incorporate the OR statement as in my previous comment.

=COUNTIFS({PriorPeriod Range 1}, Category@row, {PriorPeriod Range 2}, OR(@cell="solved", @cell = "closed"))

Paul Newcome

Try something like this...

=COUNTIFS([Column Name]:[Column Name], OR(@cell = "closed", @cell = "solved"))

Corporate Corporate

:< Cannot get it to work, formula looks like this =COUNTIFS({PriorPeriod Range 1}, Category@row, {PriorPeriod Range 2}, ="solved"). I wan it to count multiple status' in one formula

Paul Newcome

You would need to incorporate the OR statement as in my previous comment.

=COUNTIFS({PriorPeriod Range 1}, Category@row, {PriorPeriod Range 2}, OR(@cell="solved", @cell = "closed"))

Corporate Corporate

That worked, so sorry, I misunderstood. Thank you, thank you!!!

Paul Newcome

Happy to help. 👍️