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")
0
Answers
-
Are you getting an error or an incorrect count?
thinkspi.com
0