Count number of rows that contain data (rows will be dynamic)

[danniaus]

Hello

If I have a set of data that will have an unknown number of rows, how can I calculate the number of rows with data in them if the sheet will change each time

Example below, I only wish to count the rows with actual data not the blanks and because the range will change I can use a specific range

[TABLE="class: grid, width: 742"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]NMI/MIRN Quote*[/TD]
[TD]Current Retailer[/TD]
[TD]DMA provider[/TD]
[TD]Annual Peak KWh*[/TD]
[TD]Annual Shoulder KWh*[/TD]
[TD]Annual Off Peak KWh*[/TD]
[/TR]
[TR]
[TD="align: right"]6203724417[/TD]
[TD]Origin Energy[/TD]
[TD]Plus ES[/TD]
[TD="align: right"]756,063[/TD]
[TD][/TD]
[TD="align: right"]228278.09[/TD]
[/TR]
[TR]
[TD="align: right"]6203724417[/TD]
[TD]Origin Energy[/TD]
[TD]Plus ES[/TD]
[TD="align: right"]756,063[/TD]
[TD][/TD]
[TD="align: right"]228278.09[/TD]
[/TR]
[TR]
[TD="align: right"]6203724417[/TD]
[TD]Origin Energy[/TD]
[TD]Plus ES[/TD]
[TD="align: right"]756,063[/TD]
[TD][/TD]
[TD="align: right"]228278.09[/TD]
[/TR]
[TR]
[TD="align: right"]6203724417[/TD]
[TD]Origin Energy[/TD]
[TD]Plus ES[/TD]
[TD="align: right"]756,063[/TD]
[TD][/TD]
[TD="align: right"]228278.09[/TD]
[/TR]
[TR]
[TD="align: right"]6203724417[/TD]
[TD]Origin Energy[/TD]
[TD]Plus ES[/TD]
[TD="align: right"]756,063[/TD]
[TD][/TD]
[TD="align: right"]228278.09[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Rick Rothstein]

Assuming you do not want to count the header, simply pick a column whose data is numeric (like Column A) and using the COUNT function on it...

=COUNT(A:A)

 

[danniaus]

Ah it wasn't working because column A isnt always numerical, thankyou I am now using column H and it works. Thankyou