Ron Rosenfeld said:

Simpler solution for this question:

=LOOKUP(9.9E+307,Total)

will return the last entry in the Total range.


Yes, that works fine and is incredibly helpful - many thanks, Ron.

--