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
Check out the Formula Handbook template!