Formula to automatically input total number of rows
Hello! I'm hoping one of you smart people can help me...
The "$A$70" value in the calculation below is the number of rows in the sheet
I want to replace the "$A$70" value with a calculation (or whatever it's called in this case) to automatically update the "70" dynamically with however many rows in are in the spreadsheet so that whenever new rows are added or deleted, the value will change automatically.
Can someone help me do that please?
=PERCENTILE($A$2:$A$70,1/3)
Thanks a million, gang!
Manny
Comments
-
Why don't you just use =PERCENTILE($A:$A,1/3) so you sum all values in the column?
-
Hi Manny, is this in smartsheet? There doesn't appear to be a percentile formula in Smartsheet. Here is a full list of all of the available functions to use when building formulas.
-
In Smartsheet, you could reference the whole column by removing the row references.
[Column Name]:[Column Name]
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!