I'm trying to sum the number of dates with in a range for a given document type using SUMPRODUCT in the attached example spreadsheet.
I can get the formula to return the correct value for a single date, but I want to sum over a range of dates, specifically the entire week.
The formula is in Summary!C2. I thought =SUMPRODUCT(--(Dates!A2:A3
392=C1), --(Dates!B2:B392=C1+1), ...) would work but that returns 0.
What am I missing?