COUNTIF With Parameters in Two Columns

Options

I am trying to create a formula that will count the number of status of 24-72 for the month of Oct 22. I have tried a number of iterations without success.

Example formula tried (yields unparseable)

=COUNTIFS([Month Year]:[Month Year], "Oct 22", [Status:Status], "24-72")


Sheet info


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!