Sumproduct error

[bertman77]

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?

[NBVC]

Do you want to include the actual top/bottom range dates, you may need to say >= and <=?

e.g.

Please Login or Register  to view this content.

[Portuga]

Try >= and <= in the formula.

[bertman77]

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.

[bertman77]

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


Thanks everybody