I am a supporter ofSt. Joseph's hospice. If you find this site useful or if it helped you, consider a small donation toSt. Joseph's, please.
Information onSt. Joseph's
Here is a VBA function which sums the last non-empty cells of a given range:
If you are interested in downloading a 18 KB Excel 2010 sample file go to my Download page, please.
A similar function which calculates the average of the last n cells is sbAverageLast.