The first range in which to evaluate the associated criteria. To handle filtered cells use. Enter the same starting formula you used in the CountIf example but use CountIfs instead.
Question mark - matches any single character use it to count cells starting andor ending with certain characters.
To count cells between two numbers use the COUNTIFS function with the letter S at the end. How to use COUNTIFS with wildcard characters In Excel COUNTIFS formulas you can use the following wildcard characters. Absent additional criteria the CountIfs function works exactly like the CountIf function and produces the same results so the following formula is perfectly valid. As an alternative Excel has a built-in dedicated function to count blank cells called COUNTBLANK.