Count
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
Best Answer
-
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})
Answers
-
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})
-
Thank you, KDM. This worked perfectly both on the same sheet and in the cross referenced sheet. Awesome.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 444 Global Discussions
- 142 Industry Talk
- 473 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!