ExcelBanter - sum product

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - sum product (https://www.excelbanter.com/excel-discussion-misc-queries/152639-sum-product.html)

Hoyos

sum product

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

Toppers

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

Hoyos

sum product

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

All times are GMT +1. The time now is 10:26 PM.