That works well. Thanks very much
--
Hoyos


"Toppers" wrote:

=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