View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mashuganah Mashuganah is offline
external usenet poster
 
Posts: 27
Default 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?