SUMPRODUCT search between two dates

Hi,

I would appreciate any help on this formula.

Please Login or Register  to view this content.

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:

Please Login or Register  to view this content.

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!

To check between 2 dates,
the required condition's syntax is something like this:
(Range>= -- "Start Date")*(Range<= -- "End Date")
eg: (Range>= -- "1-Jan-12")*(Range<= -- "31-Mar-12")

--------------
Success? Celebrate it, hit the star button at the bottom left of my responses

Thanks Max. Its still not working for me, I've tried different variations of the formula you posted.

Maybe to clear things up, I just need it to search between the two dates, for example:

=SUMPRODUCT((TEXT(Table211[Date],"mmyy")=TEXT($B3,"mmyy"))*(Table211[Inspection Type]=G2))
*in this section here I just want it to return results between the dates I have in B3 and C3.

So how would I make (Range>= -- B3)*(Range<= -- C3) work in this formula?

> ... (Range>= -- B3)*(Range<= -- C3)
If your Start and End Dates are housed within cells, then the double minus is not required,
viz: (Range>= B3)*(Range<= C3)
where B3 and C3 must contain real dates

Try something like this in your expression, indicatively:
=SUMPRODUCT( (Range>= B3)*(Range<= C3)*(Table211[Inspection Type]=G2))