This formula results in the last nimber in a column
=index(k5:k57,count(k5:k57))
How do I get the last three numbers in a column?

Please note that this is an array formula. Within the cell in edit mode (F2)
paste this formula and press Ctrl+Shift+Enter to apply this formula. If
successful in 'Formula Bar' you can notice the curly braces at both ends like
"{=<formula}"

=SUM(LOOKUP(LARGE(IF(ISNUMBER(K5:K57),ROW(K5:K57)) ,{1,2,3}),ROW(K5:K57),K5:K57))

If this post helps click Yes
---------------
Jacob Skaria


"beginner john" wrote:


This formula results in the last nimber in a column
=index(k5:k57,count(k5:k57))
How do I get the last three numbers in a column?

Sum last three numbers in a column

Will there *always* be at least 3 numbers to sum? If, not then what should
happen?

Are there any empty/blank cells within the range?

--
Biff
Microsoft Excel MVP


"beginner john" <beginner wrote in message
...

This formula results in the last nimber in a column
=index(k5:k57,count(k5:k57))
How do I get the last three numbers in a column?