0

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?

justHelloWorld
  • 6,478
  • 8
  • 58
  • 138
  • 2
    So how would you define the area to count over? Every method of counting i can think of will need a search space defined. – QHarr Oct 12 '17 at 07:37
  • I have just included an answer https://stackoverflow.com/questions/39618868/count-non-blank-rows-in-a-certain-range-column-excel/39619052#39619052. Please check. – kelvin 004 Oct 12 '17 at 08:47

1 Answers1

0

Maybe you mean with dynamic range like:

=COUNTA(A:A)
Dmitrij Holkin
  • 1,995
  • 3
  • 39
  • 86