Syntax: Find the last entry in col C, then sum that plus the 9 entries above it.
=SUM(LOOKUP(2,1/(C:C<>""),C:C):OFFSET(LOOKUP(2,1/(C:C<>""),C:C),-9,,,))
Separately, the LOOKUP function works fine, but returns an error when used with OFFSET (in this case anyway).
Thanks
=SUM(LOOKUP(2,1/(C:C<>""),C:C):OFFSET(LOOKUP(2,1/(C:C<>""),C:C),-9,,,))
Separately, the LOOKUP function works fine, but returns an error when used with OFFSET (in this case anyway).
Thanks