Flying Hours
While I'm sure there must be a shorter solution, you can use the following
array-entered** formula to do what you asked...
=INDEX(K:K,LARGE(ROW(K1:K1000)*(K1:K1000<""),1))+ INDEX(K:K,LARGE(ROW(K1:K1000)*(K1:K1000<""),2))+I NDEX(K:K,LARGE(ROW(K1:K1000)*(K1:K1000<""),3))
** Commit this formula using Ctrl+Shift+Enter, not just Enter by itself.
I assumed a maximum data row of 1000, adjust as necessary for your actual
setup.
Rick
"Loadmaster" wrote in message
...
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.
|