The safest way hardcode a date into COUNTIF is to use the DATE function. Add a helper column with the SUBTOTAL formula that indicates if a row is filtered or not. How to use COUNTIFS with wildcard characters In Excel COUNTIFS formulas you can use the following wildcard characters.
COUNTIF A1A10.
For this clear all filters and unhide hidden rows. Enter the same starting formula you used in the CountIf example but use CountIfs instead. To count cells between two numbers use the COUNTIFS function with the letter S at the end. This is the second set of cell or range we are looking to countHowever it is not a mandatory argument.