thanks for the replies,

So far i'm not having much luck, i have to say i am a novice when it comes
to most things on excel, so i thought i'd help if i gave you the formula to
see if you could suggest where i am going wrong:

=SUMIF('[name.xls]Mid-Term'!$B$3:$B$502,SUMPRODUCT(--(MONTH(B3:B503)=11),--(YEAR(B3:B503)=2007),B3:B503),'[name.xls]Mid-Term'!$G$3:$G$502)

Range: '[name.xls]Mid-Term'!$B$3:$B$502
Criteria: SUMPRODUCT(--(MONTH(B3:B503)=11),--(YEAR(B3:B503)=2007),B3:B503)
Sum Range: '[name.xls]Mid-Term'!$G$3:$G$502

Any further help would be most welcome.





"Teethless mama" wrote:

=SUMPRODUCT(--(MONTH(A2:A100)=11),--(YEAR(A2:A100)=2007),B2:B100)


"Phendrena" wrote:

I want to sum a particular range using a date range as a criteria,
I have the dates in the worksheet formatted as dd/mm/yyyy.
How do i format this in the criteria?

For example dates for November would only be included anything else would be
ignored.

Thanks,