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)
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)
Bookmarks