Sum Based on Value


I am trying to use a formula to calculate the number of inquiries created based in a particular column.  For example, I am trying to get the total number of inquiries that have been assigned to the responsible area NAOPS.Priority.  I tried using the =SUM formula but it is giving me the overall total and not the total for that particular area.   I have attached a screenshot for review.

Best Answers