I am working on a formula to count how many times a date appears with a certain period of time, see what I have done so far
=SUMPRODUCT((F3:H3>Dates!A4)*(F3:H3<Dates!B4))

rather than have it check for dates between F3:H3 i need it to check F3, J3, N3, Q3 for the dates that fit the criteria however when i do it like this
=SUMPRODUCT((F3,J3>Dates!A4)*(F3,J3<Dates!B4))
it keeps coming up with #Value! when it should actually be 2

Any help on this would be great.

Thanks in advance


Justin.