Sum 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?
|