| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum vales found with a date range.
ok I cand understand the answers to other similar topics posted here so i am
going to have to try to explain my self... I have two .xls sheet (WorkBook1 & Woorkbook2) In Woorkbook1 on Sheet1 I have in column A incrementing dates... In Woorkbook1 on Sheet1 I have in column B Total Run Time... In Woorkbook2 on Sheet2 I have in cell A50 the START date... In Woorkbook2 on Sheet2 I have in cell A51 the END date... I am looking for a furmula that will sum the run time between and including the START and END dates. I have succeded in having the formula return a value for a single date but not for the sum of the values found winthin a date range... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extract matching vales | Excel Discussion (Misc queries) | |||
| Conditional format if cell match found in another range of cells | Excel Worksheet Functions | |||
| Conditional formatting if value in cell is found in a named range | Excel Worksheet Functions | |||
| Need an OR Function that will allow for Text vales......... | Excel Worksheet Functions | |||
| Validation error: Says range not found and it is there? | Excel Discussion (Misc queries) | |||
Threaded Mode
