Thread: sum product
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default sum product
=sumproduct(--(A6:A2000=Today()-7),H6:H2000)

"Hoyos" wrote:

How can I sum hours (cell H6:H2000) The last 7 days from todays date (cell
A6:A2000).
--
Hoyos
Reply With QuoteReply With Quote