| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum product
How can I sum hours (cell H6:H2000) The last 7 days from todays date (cell
A6:A2000). -- Hoyos |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| more sum product | Excel Discussion (Misc queries) | |||
| Sum Product vs Sum(If) | Excel Discussion (Misc queries) | |||
| product from k= 0 to n | Excel Worksheet Functions | |||
| Sum Product | Excel Worksheet Functions | |||
| Sum Product help | Excel Worksheet Functions | |||
Linear Mode
