Hi,

I would appreciate any help on this formula.

=SUMPRODUCT((TEXT(Table211[Date],"mmyy")=TEXT($B3,"mmyy"))*(Table211[Inspection Type]=F$1))
What I'm trying to do is have the formula return the count of inspections by type between two dates (measuring quarters).
The code works fine when counting items for a month from one date.

So in a nutshell how would you get the section:
=TEXT($B3,"mmyy"))
To count between two date ranges e.g. I have a table listing Q1 1-Jan-12 31-Mar-12 in separate cells.

Hope that makes sense. Thanks in advance!