I am a supporter of
St. Joseph's hospice.
 If you find this site useful or if it helped you, consider a small donation to
St. Joseph's, please.

Information on
St. Joseph's

JustGiving - Sponsor me now!

 

sbSumLast

Here is a VBA function which sums the last non-empty cells of a given range:

20110115_PB_01_sbSumLast_Screen
20110115_PB_01_sbSumLast_Code

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.

Sulprobil   Get it done   Contact   Disclaimer   Download