| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding values that fall between 2 dates
i'm using this to add values that are between 2 dates
=SUMPRODUCT(--(G8:G26=DATEVALUE("1/1/2010")),--(G8:G26<=DATEVALUE("1/30/2010")),F8:F26) but i need the dates 1/1/2010 and 1/30/2010 to be user input. so that those values are reading from another cell. is this possible |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need a function (UDF) return X if 2 dates fall between 2 other dates | Excel Worksheet Functions | |||
| Charting X values when they rise and fall | Charts and Charting in Excel | |||
| Adding amounts that fall within a range | Excel Worksheet Functions | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
| how would I count dates (not # of days) in cells that fall betwee. | Excel Worksheet Functions | |||
Threaded Mode
