Try this formula for last three numbers in K1:K100 (extend if necessary)

=SUM(IF(ROW(K1:K100)*ISNUMBER(K1:K100)=LARGE(ROW( K1:K100)*ISNUMBER(K1:K100),3),K1:K100))

This is an array formula that needs to be confirmed with CTRL+SHIFT+ENTER so
that curly braces like { and } appear around the formula in the formula bar

For last 12 just change the 3 to a 12. If there are less than 3 (or 12)
numbers then all numbers will be summed

"FSt1" wrote:

hi
can you post examples of your data that has "spaces between the figures"?

regards
FSt1

"Loadmaster" wrote:

I would like to have the sum of the last 3 entries in a column that have
spaces between the figures. I also need the sum of the last 12 entries in a
column that have spaces between the figures. Note: These figures are all in
column K.