I want to SUBTOTAL a COUNTIF function so that my COUNTIF filters as my data filters. SUBTOTAL looks like it only supports 11 functions and COUNTIF isn’t one.
You can filter COUNTIF formulas in sync with source data using the tilde operator (~) in Row Zero. The ~ is added right before the cell reference in the formula (e.g. =COUNTIF(~A:A, “>0”) and will exclude filtered and hidden rows when calculating formulas). This works similar to the SUBTOTAL function, but is more flexible and can be applied to any function or formula.
As mentioned, the SUBTOTAL function only supports 11 functions and COUNTIF is not one of them. Filtering formulas with the ~ operator is effectively a SUBTOTAL COUNTIF function. Here’s more info about filtering formulas in Row Zero along with live examples including filtering COUNTIF.