Flying Hours
If you only have numbers and/or spaces, try this *array* formula:
=SUM(A100:INDEX(A1:A100,LARGE(ROW(1:100)*(A1:A100< ""),3)))
If there might be text within the range, try this *array* formula:
=SUM(A100:INDEX(A1:A100,LARGE(ROW(1:100)*(A1:A100< "")*ISNUMBER(A1:A100),3))
)
Replace the 3 with a 12 to sum the last 12 rows.
--
Array formulas must be entered with CSE, <Ctrl <Shift <Enter, instead of
the regular <Enter, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually.
You *must also* use CSE when revising the formula.
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"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.
|