In this question is asked how to count the number of non-empty rows for a given range (e.g., A1:A100).
A1:A100
In this answer, COUNTA is used as solution. However, is there a solution without specifying the range?
COUNTA
Maybe you mean with dynamic range like:
=COUNTA(A:A)
Copyright © 2021 Jogjafile Inc.
Maybe you mean with dynamic range like: