| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare an Array to a Date Range
I'm currently using the below array equation to count records on one sheet
that match certain criteria on another sheet: {=COUNT(MATCH(Tickets!G:G, 'Staff'!A2:A15, 0))} I'm not sure how to modify it so that it also only counts records found in a given month, e.g., return a count of matching records that were created in March. There is a date field associated with each record. Ideas? |
| 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
