Using SUMPRODUCT between ranges.

[RandomPezzer]

Hi Guys,

I'm looking to add up number of cells between two date ranges in column A7:A160 but its formatted as Date & Time.

When the data came in it was just data only so I used this formula:

Please Login or Register  to view this content.

but it no longer works correctly due to the data now coming in as Date & Time format

So i'm using:

Please Login or Register  to view this content.

which does work to display one date.

how can I adapt the above formula to display data between two dates?

Thank you for your help !

[Neil_]

Guessing its your higher date that is causing the issue and that A6 and C6 are formatted as date only.
Try


=SUM(COUNTIFS(MASTER!A7:A160,">="&A6,MASTER!A7:A160,"<"&C6+1))

[Glenn Kennedy]

=SUMPRODUCT((INT(Master!$A$7:$A$160)>=A6)*(INT(Master!$A$7:$A$160)<=C6))

will also do it, but it is the higher date that's causing the problem, insofar as COUNTIFS rejects anything where the date = c6, when the data are date time.

Edit: No it looks OK

[RandomPezzer]

Thank you Neil and Glenn both formulas work, have decided to use the SUMPRODUCT formula.

Cheers