CountIFS Function

Hello

I am trying to create a countif function that states

If I select Sep from the drop down box, populate the count for the different features for the different grades.

For example- When I select sept from the list box in the monthly report tab, I want it to look up the dates on the inspection tab and if it falls in sept, I want it to count the number of times each of the features received a grading based on the inspection form in the 'inspections datasheet'. As well as checking if the month falls in sept, I want it to only count the grades of those inspections that were in the east region.

Please advise.

In B6:

Formula:

Please Login or Register  to view this content.

In B7:

Formula:

Please Login or Register  to view this content.

In B8:

Formula:

Please Login or Register  to view this content.

In B9:

Formula:

Please Login or Register  to view this content.

Copy them all across.

Well that's one way to do it anyway.

BSB