How to count the number of non empty columns without giving a range?

175 Views Asked by At

In this question is asked how to count the number of non-empty rows for a given range (e.g., A1:A100).

In this answer, COUNTA is used as solution. However, is there a solution without specifying the range?

1

There are 1 best solutions below

0
On

Maybe you mean with dynamic range like:

=COUNTA(A:A)