Count

Nadia Moreno

How do I write a formula to count rows in a dynamic sheet that sheet that keeps growing? How do I reference a column when we don't know where the end will be?

Thank you

Kelly Moore

If you're counting rows in the same sheet, try this

=Count([Column Name]:[Column Name])

This counts cells that are not blank, so choose a column that is completely filled. The column name separated by the colon indicates the entire column is included in the range. Substitute your column name into the formula.

Remember if the column name is a single word and contains no special characters you don't need to write the column name between the square brackets.

If you're counting rows in a different sheet, you need to cross reference the sheet.

=Count({Column range from other sheet})

Kelly Moore

If you're counting rows in the same sheet, try this

=Count([Column Name]:[Column Name])

This counts cells that are not blank, so choose a column that is completely filled. The column name separated by the colon indicates the entire column is included in the range. Substitute your column name into the formula.

Remember if the column name is a single word and contains no special characters you don't need to write the column name between the square brackets.

If you're counting rows in a different sheet, you need to cross reference the sheet.

=Count({Column range from other sheet})

Nadia Moreno

Thank you, KDM. This worked perfectly both on the same sheet and in the cross referenced sheet. Awesome.