Wouldn't your 2008 numbers be in the 2006 worksheet, thereby ... no problem?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Neall" wrote in message
...
I am currently using

=SUMPRODUCT(--(ISNUMBER('ALL PMRs 2007'!B$3:B$65536)),--(MONTH('ALL PMRs
2007'!B$3:B$65536)=1))

However now I need to make sure 2007 data for Jan,Feb, March etc is
seperated from the new 2008 data.

How can this be done?

--
Neall