Sigma or Summation function in Excel

0 votes
Given a value (in a cell), calculate a formula like this:

Ʃ(3i+1) for i from 0 to the value specified in the cell.

SUM(), SERIESSUM() are not suitable in this case. How can I do this in Excel? Much thanks!
Mar 11 in Database by Edureka
• 9,320 points
21 views

1 answer to this question.

0 votes

The SUM function in Excel is another way to add numbers. Type =sum() into a cell to utilise the SUM function. Within the parenthesis, type the cell references for the cells you want to add. The AutoSUM button, which resembles the Greek letter sigma, inserts the SUM function into a cell automatically.

Excel's Addition
By clicking on any cell and inputting the = sign, followed by the numbers you want to add together separated by a + symbol, you can use Excel as a calculator to add numbers.

Using Excel as an example, add 9+7.

Type "=9+7" into any cell (without the quotation marks).

The SUM function is another way to add integers in Excel. In a cell, type =sum() to utilise the SUM function. Within the parenthesis, put the cell references for the cells you want to add.

The AutoSUM button, which resembles the Greek letter sigma, will insert the SUM function into a cell automatically.

image

Values Separated by a comma
This is used to combine the values of several cells. Within the function, commas are used to separate the cell references. These cells in the spreadsheet don't have to be next to each other.

Example: Combine the values of cells A2 and A3.

The value of A2 is 9.

The value of A3 is 7.

In another cell, type "=sum(A2,A3)" (without the quotation marks).

answered Mar 15 by Edureka
• 8,820 points

Related Questions In Database

0 votes
0 answers

How to loop in excel without VBA or macros?

Is it possible to iterate (loop) a ...READ MORE

Mar 30 in Database by Edureka
• 9,320 points
63 views
0 votes
1 answer

Using SQL "IN" Function in Excel

MATCH is a word that can be ...READ MORE

answered Apr 4 in Database by Edureka
• 9,320 points
13 views
0 votes
1 answer

How can we achieve excel ceiling function with significance value in SQL Server

If the underlying data types and rounding ...READ MORE

answered Apr 4 in Database by Edureka
• 8,820 points
29 views
0 votes
1 answer

#NAME? error in Excel for VBA Function

Because you have a module with the ...READ MORE

answered Apr 5 in Database by Edureka
• 8,820 points
34 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,720 points
324 views
0 votes
1 answer

ImportError: openpyxl is required for loading excel format files

Forget the PsychoPy complications for the time ...READ MORE

answered Oct 3, 2018 in Python by Priyaj
• 58,060 points
290 views
0 votes
1 answer

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

answered Oct 15, 2018 in RPA by Priyaj
• 58,060 points
3,130 views
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,160 points
2,525 views
0 votes
1 answer

how do I calculate discount with if function in excel?

Suppose a customer gets a 10 percent ...READ MORE

answered Feb 23 in Database by Edureka
• 8,820 points
169 views
0 votes
1 answer

how do I calculate discount with if function in excel

Notes about the release; Frameworks to aim ...READ MORE

answered Mar 25 in Database by Edureka
• 8,820 points
25 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP