=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.