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.