Sumproduct

A

augam

Hi all!
I am trying to use Sumproduct with dates that come off an SQL databas
and are in the format of 02/12/2003 15:30.

This is forcing me to use the following formula
=SUMPRODUCT((Data!$E$2:$E$3893>G$3)*(Data!$E$2:$E$3893<G$2)*(Data!$C$2:$C$3893=$A4)*(Data!$G$2:$G$3893))

where $G3 is 02/12/2003 00:01 and $G2 is 02/12/2003 23:59

Is there any way I can just look at the date only rather than the time
as well, so that anyone can enter a date from, and a date to

In anticipatio
 
P

Peo Sjoblom

Use SUMPRODUCT((INT(Data!$E$2:$E$3893)>G$3)*

and so on, that will shave off the times from the values
--

Regards,

Peo Sjoblom


augam said:
Hi all!
I am trying to use Sumproduct with dates that come off an SQL database
and are in the format of 02/12/2003 15:30.

This is forcing me to use the following formula
=SUMPRODUCT((Data!$E$2:$E$3893>G$3)*(Data!$E$2:$E$3893<G$2)*(Data!$C$2:$C$38
93=$A4)*(Data!$G$2:$G$3893))

where $G3 is 02/12/2003 00:01 and $G2 is 02/12/2003 23:59

Is there any way I can just look at the date only rather than the times
as well, so that anyone can enter a date from, and a date to

In anticipation
creating financial statements
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top