How do include Dates in a formula?
 

I currently have this:

=SUMIF('SP3(06) LEADS'!$F$2:$F285,"Tim",'SP3(06) LEADS'!V2:V285)

what im look for is to include dates from 8/03/2006 to 15/03/2006.
Something like this but im not sure how to do it.

SUMIF(AND(SP3(06) LEADS'!$A$2:$A285=DATE(8/03/2006),SP3(06)
LEADS'!$A$2:$A285<=DATE(15/03/2006)),SP3(06) LEADS'!V2:V285,0)

Pretty much what I want is to sum all the numbers column V that have 'Tim'
in F and that are in the date range of 8/03/2006 to 15/03/2006 which is in
column a.
Note I am not using normal year/month/day format.

Also the data is on another work sheet called SP3(06) LEADS.

Thanx in advance.

How do include Dates in a formula?
 

=SUMPRODUCT(--('SP3(06) LEADS'!$F$2:$F285="Tim"),--('SP3(06)
LEADS'!$A$2:$A285DATE(2006,3,8)),--('SP3(06)
LEADS'!$A$2:$A285<DATE(2006,3,15)),'SP3(06) LEADS'!V2:V285)

GIVE THAT A TRY

"Grisha" wrote:

I currently have this:

=SUMIF('SP3(06) LEADS'!$F$2:$F285,"Tim",'SP3(06) LEADS'!V2:V285)

what im look for is to include dates from 8/03/2006 to 15/03/2006.
Something like this but im not sure how to do it.

SUMIF(AND(SP3(06) LEADS'!$A$2:$A285=DATE(8/03/2006),SP3(06)
LEADS'!$A$2:$A285<=DATE(15/03/2006)),SP3(06) LEADS'!V2:V285,0)

Pretty much what I want is to sum all the numbers column V that have 'Tim'
in F and that are in the date range of 8/03/2006 to 15/03/2006 which is in
column a.
Note I am not using normal year/month/day format.

Also the data is on another work sheet called SP3(06) LEADS.

Thanx in advance.

How do include Dates in a formula?
 

You need 2 SUMIF and the DATE function is incorrect

=SUMIF(Range1,"="&DATE(2006,3,8),Range2)-SUMIF(Range1,""&DATE(2006,3,15),Range2)

another way would be to use SUMPRODUCT

=SUMPRODUCT(--(Range1=DATE(2006,3,8)),--(Range1<=DATE(2006,3,15)),Range2)

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com




"Grisha" wrote in message
...
I currently have this:

=SUMIF('SP3(06) LEADS'!$F$2:$F285,"Tim",'SP3(06) LEADS'!V2:V285)

what im look for is to include dates from 8/03/2006 to 15/03/2006.
Something like this but im not sure how to do it.

SUMIF(AND(SP3(06) LEADS'!$A$2:$A285=DATE(8/03/2006),SP3(06)
LEADS'!$A$2:$A285<=DATE(15/03/2006)),SP3(06) LEADS'!V2:V285,0)

Pretty much what I want is to sum all the numbers column V that have 'Tim'
in F and that are in the date range of 8/03/2006 to 15/03/2006 which is in
column a.
Note I am not using normal year/month/day format.

Also the data is on another work sheet called SP3(06) LEADS.

Thanx in advance.