COUNTIF function is a premade function in Excel. Countif is an Excel function to count cells in a range that meet a single condition. COUNTIF can be used to count cells that contain dates, and numbers.