Use COUNTIFS() to evaluate multiple count and criteria ranges ... Excel's COUNTIFS() function is flexible enough to handle different ranges and data types.
