+3 votes
112 views
in Office by (242k points)
reopened
Excel: insert sum symbols

1 Answer

+4 votes
by (1.6m points)
 
Best answer

Insert sum symbol in Excel
1st step:
2nd step:
3rd step:
Quick guide: inserting summation symbols in Excel

Are you wondering how to insert the sum symbol ∑ in Excel? We'll show you..

image image

With Excel you can not only create tables, but also do calculations. You may need the sum symbol ∑ to indicate sums. In this practical tip we will show you how to insert this into Excel.

Insert sum symbol in Excel

The sum symbol ∑ is often used to mark a sum in Excel tables. On the other hand, to calculate a sum, i.e. to add up the values ​​of a row, you need a formula or a ready-made function. Here you will learn how to paste the ∑ into Excel. Follow our step-by-step instructions or take a look at the brief instructions .

1st step:

image
Click in the cell where you want to insert the sum sign. Switch to the " Insert " tab . In the " Symbols " area, click on " Symbol ".

2nd step:

image
A window will open. Select " (normal text) " in the left drop-down menu and " Mathematical operators " in the right .

3rd step:

image
Scroll to the sum symbol and select it. Click on " Insert ", the character will be inserted in the background. You can insert additional symbols or the " Close " window .

Quick guide: inserting summation symbols in Excel

  1. Select the cell in which you want the sum symbol. In the " Insert " tab, click on " Symbol " in the " Symbols " area .
  2. In the window that opens, select " (normal text) " at the top left and " Mathematical operators " on the right .
  3. Select the sum symbol ∑ . Click on " Insert " to insert the character in the background. " Close " the window.

...