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

NMI/MIRN Quote*	Current Retailer	DMA provider	Annual Peak KWh*	Annual Shoulder KWh*	Annual Off Peak KWh*
6203724417	Origin Energy	Plus ES	756,063		228278.09
6203724417	Origin Energy	Plus ES	756,063		228278.09
6203724417	Origin Energy	Plus ES	756,063		228278.09
6203724417	Origin Energy	Plus ES	756,063		228278.09
6203724417	Origin Energy	Plus ES	756,063		228278.09

<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[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