"Sigma" function in Excel?

Hi, I of the simplest way would be creating your own function.

Following are the steps to do it:

Press Alt+F11 in your excel worksheet.
You will see a visual basic window. On the left hand side, you will have a Project window where all the available sheets are listed down. Right click and insert a module and paste the below mentioned code in the module: (From Function to End Function only)

Function Sigma(i As Integer) As Long
Dim j As Integer
Sigma = 0
For j = 1 To i
    Sigma = Sigma + (1 + (2 * (j - 1)))
Next

End Function

Save the file and enable the macros by going into Tools-Macros-Security-enable macros

In the workbook now you can use your own created function named as Sigma.

format would be: =Sigma(cell reference)

Hi, a non VBA solution could be

=SUMPRODUCT(1+2*(ROW(INDIRECT("1:"&$A$1))-1))

In A1 your maximum value (4 in the example).

Hope it helps you.

ermmm

anybody else notice the series?

1=1 2=4 3=9 4=16 5=25

sigma = a1^2

Roshan10043,

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Hope I didn't inadvertently give the answer to what the spreadsheet was trying to figure out!

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.