Sumproduct error

I'm trying to use sumproduct to get data between 2 dates, date ranges are in a column.

Please Login or Register  to view this content.

I can't just have it =datesA16 because the time of day throws it off.

It's not giving me the correct data based on the dates.

Am I missing something?

actually, no i don't want to include >= and <=

my data has dates and times in it.

if it was simply the date I could have it equal to the cell on the dates sheet, the trouble is that the time of day throws it off.

so if my data has 3 entries from today, but at different times, the sumproduct isn't picking them up correctly because the date isn't exactly the same as the one it's trying to reference.

never mind, it was as simple as adding the >= after the first argument only.


Thanks everybody