Sumproduct

[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

 

[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

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


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to

creating financial statements

 

[augam]

Thanks a lot, that worked.