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
-
Are you getting an error or an incorrect count?
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!