Can you use match within a countifs function?

[Salient]

Two part check.

1. Does a date match another date - COUNTIFS, no problems

2. Here's the tricky part, in the second criteria I want to see if a single cell occurs in a name range.

Can this be done within a COUNTIFS function or is it back to the drawing board on this one. :think:

[Salient]

Okay came up with this, not entirely sure it's returning a simple count however.

=SUMPRODUCT((Sheet2!B:B=A4)*(ISNUMBER(MATCH(Sheet2!C:C,ErrorArray,0))))

Will need to test this a few ways...

[Bob Phillips]

Is ErrorArray a multi-cell range here?