Count Multiple Items in the Same Column


Hi Smartsheets Team,

I am trying to write a formula to count the number of rows in a column to sum up the amount of times two different values appear. To clarify, each row has one value. I am trying to find the number of time two different values appear in the column. I've tried a few things based off questions here with no luck. This is my latest try:

=COUNTIF(Status1:Status1000, ="100% Sprint Task Complete", [Status1]:[Status1000], = "100% Config Moved to Config Master"))

Any help would be great! Thank you.

Best Answer