How can I sum hours (cell H6:H2000) The last 7 days from todays date (cell A6:A2000).
H Hoyos Aug 1, 2007 #1 How can I sum hours (cell H6:H2000) The last 7 days from todays date (cell A6:A2000).
H Hoyos Aug 2, 2007 #3 That works well. Thanks very much -- Hoyos Toppers said: =sumproduct(--(A6:A2000>=Today()-7),H6:H2000) Click to expand...
That works well. Thanks very much -- Hoyos Toppers said: =sumproduct(--(A6:A2000>=Today()-7),H6:H2000) Click to expand...
