How To: Excel Sigma Summation Function ∑f(x)

You can download the Add-In here (SigmaSumsScrubbed.xlam): github.com/DavidD003/VBAMacros

If you wish to support my work, you can find me on Patreon:
patreon.com/DavidD003

Benefits of supporting me include access to all my code with full commenting, having me debug code for you, and having me write code for you!

This video shows how to use the custom function (UDF, User Defined Function) I made for the purpose of computing ∑f(x) - type summation in a single cell. In particular, I go over how to enter the arguments into the formula properly so as to compute what you intend. These are presented below:

SigmaSums
Argument 1: The function for evaluation, as a string
Argument 2: The variable argument which iterates, as a string
Argument 3: The arguments lower bound for summation
Argument 4: The variables upper bound for summation
Argument 5: (Optional) The step-value for incrementation

MultiSigmaSums
Argument 1: The function for evaluation, as a string
Argument 2: A 1 row {array} containing the variable argument which iterate, as strings. These must be entered in the sequence that the large sigmas are presented.
Argument 3: An n-row array, for n iterating variables. Each row should contain three variables in sequence: the lower bound of summation, upper bound, and step value