Counting non-empty cellsThe COUNTBLANK-COUNTA conflict (and how to fix it)Summary: Choosing the right counting functionIn ...
The SCAN function lives in a single cell and spills the results down the column, ensuring my totals are always structurally ...