Formula to automatically input total number of rows

04/08/19 Edited 12/09/19

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

Tags:

Comments

  • LGollerLGoller ✭✭✭✭✭

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

  • Mike WildayMike 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 NewcomePaul Newcome ✭✭✭✭✭

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

     

    [Column Name]:[Column Name]

    thinkspi.com

Sign In or Register to comment.