How do include Dates in a formula?

[Grisha]

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.

[Duke Carey]

=SUMPRODUCT(--('SP3(06) LEADS'!$F$2:$F285="Tim"),--('SP3(06)
LEADS'!$A$2:$A285>DATE(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.
>
>

[Peo Sjoblom]

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" <[email protected]> wrote in message
news:[email protected]...
>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.
>
>