Try something like this...

=SUMPRODUCT(--(MONTH(date_range)=3),--(ISNUMBER(MATCH(Tickets!G1:G100,'Staff'!A2:A15,0)) ))

--
Biff
Microsoft Excel MVP


"Mashuganah" wrote in message
...
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?