| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare an Array to a Date Range
Good deal. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Mashuganah" wrote in message ... Biff, I finally got it to work. The final form was: =SUMPRODUCT(--(MONTH(Tickets!A2:A25000)=10),--(ISNUMBER(MATCH(Tickets!G2:G25000,'TAC Staff'!A2:A15,0)))) Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT with Date Range Array | Excel Discussion (Misc queries) | |||
| Return array of data by date range | Excel Discussion (Misc queries) | |||
| Return an array of data based on range of date | Excel Worksheet Functions | |||
| date range table array formula | Excel Worksheet Functions | |||
| Compare date of a transaction against a range of dates | Excel Worksheet Functions | |||
Threaded Mode
