Hi Mark

This is an example of my formula:

=SUMIF(filename.xls]MAY'!$O$8:$O$300,41029,'filename.xls]MAY'!$AD$8:$AD$300)

There is one of these for each month (entered manually), then I copied/pasted them and changed the excel date number for others...........so in answer to your question there are both.

Hope this makes sense!