Hi All,
I am trying to use a formula to help get a count of the number of total incidents on a monthly basis. In the attachment below, please reference the All Regions Incident Type sheet.
An example of what I'd like to see is the sum of column D for each month (using either the actual month name in column C or the month number in column E). Then I want to take the average of that number to get a daily average of incidents for the month.
Example of Formula 1 = SUM of ALL JANUARY incidents using COUNT from column D.
Example of Formula 2 = AVERAGE OF ALL JANUARY incidents using SUM from Formula 1 and number of days in the month of JANUARY.
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