Insert Sigma Symbol (SUM Symbol) in Excel

The Sigma symbol (Σ) is extensively used in mathematics, statistics, and science, primarily representing summation in mathematical equations.

It’s a key symbol in calculus for summing a sequence of numbers, and in statistics, it’s often used in formulas for calculating standard deviation.

In this article, I will show you some simple ways to insert the Sigma symbol in Excel

Keyboard Shortcut to Insert Sigma Symbol in Excel

Below are the keyboard shortcuts to insert the Sigma symbol in Excel:

Sigma Shortcut On Windows in Excel:

Alt + 228
  1. Ensure that the Num Lock is On in your keyboard.
  2. Hold down the Alt key.
  3. Type 228 on the numeric keypad.
  4. Release the Alt key to get the Sigma symbol in the cell.

Mac does not have a direct keyboard shortcut for the Sigma symbol in Excel. The symbol is typically inserted using the Symbol dialog box.

Also read: Insert Omega Symbol In Excel

Inserting Sigma using the Symbol Dialog Box

To insert the Sigma symbol in Excel using the Symbol Dialog Box, follow these steps:

  1. Click on the cell where you want to insert the symbol.
  2. Go to the Insert tab on the ribbon.
Click the insert button
  1. Click on Symbol in the Symbols group.
Click the symbols icon to open the Symbol dialog box
  1. In the Symbol dialog box, select Greek and Coptic from the Subset dropdown.
Select Greek and Coptic subset from the drop down
  1. Find and select the Sigma symbol (Σ).
Select the Sigma symbol in the symbol dialog box
  1. Click Insert, then close the Symbol dialog box.
Click on the insert button to insert the Sigma symbol

Inserting Sigma Symbol using Formula

In Excel, you can use the CHAR function to insert the Sigma (SUM) symbol:

=UNICHAR(931)
Formula to insert the sigma symbol in a cell in Excel
Also read: Get Euro Symbol in Excel

Copy and Paste the Sigma Symbol into Excel

You can also copy the sigma symbol (sum symbol) from this web page or any other Excel file or document such as Microsoft Word or Microsoft PowerPoint and then paste it into a set in Excel.

Σ

Below is a table that summarizes all the methods to insert the Sigma symbol in Excel:

DescriptionDetails
Name of SymbolSigma Symbol / Sum Symbol
Symbol TextΣ
Shortcut for WindowsAlt + 228
Shortcut for MacUse Symbol Dialog Box
Inserting using Symbol Dialog BoxFind Σ in the Symbol dialog box under Greek and Coptic
Inserting using Formula=UNICHAR(931)

This article covers methods to insert the Sigma symbol in Excel, accommodating Windows and Mac users.

Whether using keyboard shortcuts, the Symbol dialog box, or formulas, these methods facilitate the inclusion of Σ in your Excel documents.

Other Excel articles you may also like:

I am a huge fan of Microsoft Excel and love sharing my knowledge through articles and tutorials. I work as a business analyst and use Microsoft Excel extensively in my daily tasks. My aim is to help you unleash the full potential of Excel and become a data-slaying wizard yourself.

Leave a Comment