COUNTIFS

Karen Passmore

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")

Paul Newcome

Are you getting an error or an incorrect count?