COUNTIFS function - Support

Applies criteria to cells across multiple ranges and counts the number of times all criteria are met. ... If the criteria argument is a reference to an empty cell, the COUNTIFS function treats the ... In Excel, create a blank workbook or worksheet.

support.office.com