Last value in a range (Return)?

edited 12/09/19 in Smartsheet Basics

I have a column (set of cells) which I'm using to attain Sum and Count figures from a series / row of numeric information. In addition I need to return the last entry made in the series. For example: There are 52 weeks in the year and we are collating information weekly and entering these figures into the corresponding cells...A summary column is used to Sum, Avg and count these cells up - what's missing is the last entered field i.e. week 8 being my last entered field (at present).

Is there a formula or easy way to do this (help would be greatly appreciated)?