Thread: =SUMPRODUCT but need to break out Jan 07 and Jan 08 results
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Neall Neall is offline
external usenet poster
  
Posts: 95
Default =SUMPRODUCT but need to break out Jan 07 and Jan 08 results
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
Reply With QuoteReply With Quote