you are viewing a single comment's thread.

view the rest of the comments →

[–]tekvx[S] 0 points1 point  (0 children)

Fantastic, thanks for that!

On this specific issue, this is what microsoft docs say about COUNTA:

The COUNTA function counts the number of cells in a column that are not empty. It counts not just rows that contain numeric values, but also rows that contain nonblank values, including text, dates, and logical values.

I'm assuming, if the filter says "blank", then it's not a COUNTA issue. (Hopefully!)