Hello every one, first time user here. I am having trouble using COUNTIFS formulas to work out the below. I would like to find out the total number of incidents that occurred for each business within a reporting period. I can work out the totals however i cannot seem to get the formula to work within the reporting dates.
Cell B20: =COUNTIFS(B4:B17,B19,C4:C17,A20)
Example.jpg
Sorry for some reason i could not attach a workbook.
Bookmarks