Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
hi, i'm trying to look in column A for a date that falls within a specific
time frame, then look in column B to see if that date is than the date in column A, if it is, then add the qty in column C. ex: A1: 5/22/08 B1: 5/23/08 C1: 4 A2: 5/23/08 B2: 5/23/08 C2: 2 so if formula is look in col A for all dates within 5/19 and 5/22, then i want the result to show 4. tia |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date function in ACCRINTM requires date format not available | Excel Worksheet Functions | |||
MAX figure within a date range as a function of today()'s date | Excel Worksheet Functions | |||
SUMIF within date range as a function of today()'s date | Excel Worksheet Functions | |||
Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions |