Use COUNTIFS() to evaluate multiple count and criteria ranges ...

Excel's COUNTIFS() function is flexible enough to handle different ranges and data types.

www.techrepublic.com