Hello
I need some help on getting a count function working using sum product.
What I want is If I select a quarterly month in the list box on 'quarterly reports', I want it to count the number of inspections as shown on the 'inspections' data sheet for those 3 months.
I have tried to use this formula but not picking up the months
=SUMPRODUCT((TEXT(Inspections!$A$2:$A$5,"mmm")=$A$4)*(Inspections!E$2:E$5>=6)*(Inspections!E$2:E$5<=7))
Bookmarks