How To Type The Sum Symbol Sigma In Excel - 2575

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Mar 17, 2023.
Several people asked about typing a Sigma or the Sum Symbol in Excel. There are several different ways to do this, and none are particularly easy to figure out. Perhaps the best way is =UNICHAR(931) followed by F9.

This video answers these search terms:
how to do sigma in excel
how to find sigma in excel
how to find the sum symbol in excel
how to get sum symbol in excel
how to get the sum symbol in excel
how to insert sum symbol in excel
how to type sigma in excel
how to use sigma in excel
what is the sum symbol called in excel
maxresdefault.jpg


Transcript of the video:
How to type the sum symbol in Excel.
I'm reading these queries and I think you're actually trying to type the Sum symbol in Excel.
This thing called the Sigma.
It's easy to use the AutoSum.
It is hard to type this thing.
You're going to think I'm insane, but I think the actual easiest way to do it is equal UNICHAR(931).
Press the F9 key and there you have a Sigma.
There's other ways.
You can hold down the flying Windows Key and the period.
Which starts out with a bunch of emojis.
Come into the math section.
Scroll down, Scroll down, Scroll down, right there.
There are still other ways.
On the Insert tab.
Far right hand side, Symbol.
Choose whatever font you're using.
And then in the Subset drop-down, choose either Greek or down to mathematical operators.
Choose Sigma, click insert.
And that works.
Or check out this crazy one.
On the Insert tab, underneath the Equation.
There is a bunch of equations that have a Sigma.
But all the way down at the bottom there's something called Ink Equation.
And just very carefully do your best to draw a Sigma.
And it figures it out.
And you can Insert.
It ends up as a little text box there and you can change the font.
You're going to think I'm crazy, but It's just easier to learn =UNICHAR(931) F9, Enter.
If you like these videos, please, down below, Like, Subscribe, and Ring the bell.
Feel free to post any questions or comments down in the comments below.
 

Forum statistics

Threads
1,221,517
Messages
6,160,264
Members
451,635
Latest member
nithchun

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top