Thread: Sumproduct Datevalue Problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
andyp161
 
Posts: n/a
Default Sumproduct Datevalue Problem

Hi there,

I have written the following formula, which works fine:

=SUMPRODUCT((Sheet1!$S$2:$S$27488=DATEVALUE("31/3/2006"))*(Sheet1!$O$2:$O$27488=(Sheet2!$A3)))

However, I actually want to return values for whole months rather than
specific dates ie replace "31/03/2006" with "March".

Hope you can help.

Many thanks


--
andyp161
------------------------------------------------------------------------
andyp161's Profile: http://www.excelforum.com/member.php...o&userid=11654
View this thread: http://www.excelforum.com/showthread...hreadid=520548

Reply With QuoteReply With Quote