Excel: Sum series of function calls
I have the following simple function that I need to call n times and sum the result.
I wish to call this 30 times, with n being 1-30, then sum the result. How can I do this in Excel?
You can use the following array formula.
Paste the formula into the formula bar and press Ctrl+Shift+Enter. It doesn't matter where you enter the formula or what the contents of A1:A30 are; the A1:A30 is just a trick to get Excel to iterate through the formula 30 times.