Sumproduct error

**bertman77** · 04-15-2008, 12:58 PM

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

=SUMPRODUCT(--(data!$D$2:$D$493>dates!A15),--(data!$D$2:$D$493<dates!A17),--(data!$C$2:$C$493))

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** · 04-15-2008, 01:09 PM

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

e.g.

=SUMPRODUCT(--(data!$D$2:$D$493>=dates!A15),--(data!$D$2:$D$493<=dates!A17),--(data!$C$2:$C$493))

**Portuga** · 04-15-2008, 01:09 PM

Try >= and <= in the formula.

**bertman77** · 04-15-2008, 01:14 PM

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.