=COUNTIF(B4:B50,"=1")
put this in the D6 cell..."Misc Single Incidents"

you can set the range "B4:B50" to as far down as you want....this is not a very elegant solution for the range....you can use a named range (or dynamic name range), which is a little neater...so this should be fairly dynamic when you change you filter to see each location....