COUNTIFS

I am trying to count number of appointments by quarter by territory for a particular rep. The rep may be in several territories. This is the formula I had been using but now need to count another territory, SLG AG.

Formula #1 without counting SLG AG is successful

=COUNTIFS({Activity Metrics Range 3}, ">=SLG PS1", {Activity Metrics Range 3}, "<=SLG PS4", {Activity Metrics Range 1}, "Q1")

Formula #2 adding SLG AG unsuccessful

=COUNTIFS({Activity Metrics Range 3}, ">=SLG PS1", {Activity Metrics Range 3}, "<=SLG PS4", {Activity Metrics Range 1}, "SLG AG", {Activity Metrics Range 1}, "Q1")

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!