Formula to automatically input total number of rows

Manny

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

LGoller

Why don't you just use =PERCENTILE($A:$A,1/3) so you sum all values in the column?

Mike Wilday

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. 

https://help.smartsheet.com/functions

Paul Newcome

In Smartsheet, you could reference the whole column by removing the row references.

 

[Column Name]:[Column Name]