Count new rows

How do I count the number of rows with data minus my header row?

I want to send an email indicating how many responses are in a Google Sheet but it keeps counting my total rows, including my header, so the count is always +1 more than it should be.

I have tried to set the range to start at row #2, but it still counts row #1.



Screenshot 2024-05-02 092305

Instead of a numeric aggregator, you can use the array aggregator to aggregate the bundles into an array, then use the built-in function length on the array.

1 Like