Ʃ: How to Easily Insert Sum / Total Sign “Ʃ” in Excel

You have created a nice dashboard in Excel? Or a beautiful Profit and Loss calculation? Now, you want to bring it to the next level: Insert the sum or total sign, the Greek character sigma: Σ. In general mathematics, uppercase Σ is used as an operator for summation. Here is how to quickly do this in Excel!

The fastest method for Windows: Professor Excel Tools

Insert the SUM / Total sign Σ with Professor Excel Tools.
Insert the SUM / Total sign Σ with Professor Excel Tools.

This is the fastest method: Go to the Professor Excel ribbon, click on the drop-down arrow of “Insert Symbol” and then on the total sign sigma Σ.

Just download and install the Excel-add-in Professor Excel Tools and see if it works for you.


Professor Excel Tools Box

This function is included in our Excel Add-In ‘Professor Excel Tools’

(No sign-up, download starts directly)

More than 35,000 users can’t be wrong.


Insert Total Sign (Σ) in Windows

Method 1 in Windows

The “traditional” way to insert the operator of summation sigma in Windows is through the Insert Symbol window:

Insert the Total Sign in Windows.
Insert the Total Sign in Windows via the Insert Symbol window.
  1. On the Insert ribbon, click “Symbol” (the right-most button).
  2. In the Symbol window, select “Unicode (hex)” in the from field.
  3. Type 03A3 into the “Character code” field. You should now see the Greek character sigma selected above.
  4. Click on Insert to insert the symbol into the cell or chart.

Method 2 in Windows

Probably not as beautiful, but it usually works: Alternatively, just copy and paste it from here.

Σ

Insert Total Sign (Σ) in Mac

It’s almost the same in Mac OS as in Windows, but the window looks a bit different. Still, you have to go to the Insert ribbon and click on Symbol on the right-hand side:

  1. On the Insert ribbon, click on Symbol (on the right-hand side).
  2. In the Character Viewer, go to Mathematical Symbols.
  3. Insert the Σ by double-clicking on it.

Add the Greek Letter Sigma to a chart

You want to show the operator of summation Σ on a chart? It works the same way as described above. The only difference: Insert a text field first.

Before you can insert the total sign on a chart, insert a Text Box on it.
Before you can insert the total sign on a chart, insert a Text Box on it.

In order to do this, select your chart. Then go to the Insert ribbon. On the right-hand side, click on the button “Text Box” and draw it onto the chart. Now, you can simply copy & paste or insert the total sign Σ there.

Image by Pexels from Pixabay

Henrik Schiffner is a freelance business consultant and software developer. He lives and works in Hamburg, Germany. Besides being an Excel enthusiast he loves photography and sports.

Leave a comment

Your email address will not be published.