Hi All,
I am trying to use a formula to help get a count of the number of total incidents by priority on a monthly basis while excluding certain 'types' of incidents. In the attachment below, please reference the APAC All Months Summary sheet.
An example of what I'd like to see is the number of "P1" and "P2" (cells A56 and A57; with individual count for each value) for each month (or for the entire 6-month range). However, I do not want that number to include "P1" or "P2" associated with the following types:
1. Duplicate Incident Opened, Do Not Report (A68)
2. Incident Opened in Error (A69)
I would like to keep the worksheet in its current format and do not want to add any additional columns, because I need the data for importing into Power BI for reporting purposes. I have used this formula to return a count of the number of "P1" for each month =COUNTIFS(March!$E$2:$E$10000, A68) but cannot get it to exclude certain incident types.
Example of Wanted Formula = COUNT of ALL March (or March-August if able) P1 incident types not including 'duplicate incident...' or 'incidents opened in error'
Hope the request make sense. I have been playing around with a couple of different formulas I found online to no avail and this forum has always come through in the past.
Thanks in advance for any response with help! Much Appreciated
-John
Bookmarks