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, 2022 in Database 11,966 views

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.

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.

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).

• 23,260 points

How to loop in excel without VBA or macros?

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

Using SQL "IN" Function in Excel

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

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

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

#NAME? error in Excel for VBA Function

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

Retrieve epay.info Balance with VBA and Excel

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

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

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

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

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

try this. let TableA = ...READ MORE