Look at what you've asked your formula to do.

You have asked it to add the values in column G on your Mid-Term sheet in
name.xls, for the rows where the value in column B on that sheet is equal to
the value of the specfied criterion, which is obtained from by multiplying
column B on your current sheet by two Booleans, one checking that the month
of the date in column B of your current sheet is November, and the other
checking that the year in that column is 2007. [And additionally you've got
unequal ranges, some going to row 502 and some to 503.]

I doubt whether that's what you intended. I guess that the SUMPRODUCT
formula was intended to give your answer, not to be used as the crierion in
the SUMIF formula.
--
David Biddulph

"Phendrena" wrote in message
...
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,