Summation Examples (VBA)

I was asked by a student to assist writing some VBA code. The assignment, as per the student: There are 2 ways to solve this, the usual iterative way and a mathematical away. The mathematical way is smarter.
In the first: The second is more like an equation: Included in the ZIP file is both the code as text file, as well as an Excel 2007 file that uses the functions in equations accessible to the user.

Click the download button for VBA_ArraySummation_Examples.zip... Download Code