=LOOKUP(9.99999999999999E+307,A:A)

would fetch the last numerical value from column A.

Bob wrote:
I need assistance in choosing the correct function so that I can obtain the
last calculated value in a column range as each month another value is added
to the list.