Thread: Sumproduct Will Not Find Date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
andyp161
 
Posts: n/a
Default Sumproduct Will Not Find Date

Does the SUMPRODUCT function find dates? An example of my formula,as
follows, will not work i.e.returns "0":

=SUMPRODUCT(($A$1:$A$200="26/10/2004)*($B1$B200=$C1))

Please let me know if when using date references I have to do something
extra?

Thanks

Andy


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

Reply With QuoteReply With Quote