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!