Thread: Can I check if a date falls between a range then sum other # if tr
View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default
=SUMPRODUCT(--(A2:A20=--"2005-10-01"),--(A2:A20<=--"2005-10-31"),B2:B20)

--
HTH

Bob Phillips

"clovins1" wrote in message
...



Reply With QuoteReply With Quote