Thread: Adjusting a formula to collect data between two dates?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Hoyos Hoyos is offline
external usenet poster
  
Posts: 74
Default Adjusting a formula to collect data between two dates?
How can modify the formula below so that its criteria is between two dates?

=IF(AF16="",NA(),SUMPRODUCT(--(Date=AF16),Value)

Thank you.
Reply With QuoteReply With Quote