Thread: SUMIF between 2 dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rhhince[_2_] rhhince[_2_] is offline
external usenet poster
  
Posts: 48
Default SUMIF between 2 dates
Summing it falls between to dates. This is not working. Need a fix. Thanx!


=SUMIF(b17:b50000,""&DATE(1/1/2003),b17:b50000,"<"&DATE(12/31/2003),n17:x50000)

Ray
Reply With QuoteReply With Quote