Evaluating Sigma Notation in Excel and Google Sheets

Many people assume Excel has a dedicated sigma notation button that lets you type a sum like Σ(i² + 1) from i=1 to 10 and get the answer. It does not. The Σ icon on the toolbar runs the SUM function, which adds a range of cells you already filled in. That is not sigma notation. To evaluate sigma notation in Excel you have to build the sequence of terms yourself and then add them. Four spreadsheet methods exist: helper columns, SEQUENCE with SUM, SUMPRODUCT, and SUMSQ. The same techniques work in Google Sheets.

The core idea is that sigma notation is shorthand for "generate these numbers and add them up." The spreadsheet does the generating and the adding. You just have to tell it the index variable, the lower bound, the upper bound, and the summand expression.

This method shows every term in the sum. It is the safest way when you are learning or when the summand is complex enough that you want to check each value.

How To Build the Term Column

Assume you want to evaluate Σ(2i + 3) for i = 1 to 5. In cell A1 type the lower bound: 1. In A2 type =A1+1. Drag that formula down to A5. Column A now holds the index values 1,2,3,4,5. In B1 type =2*A1+3. Drag that down to B5. Column B now holds the terms: 5,7,9,11,13. In B6 type =SUM(B1:B5). The result is 45.

The failure case: off-by-one errors in the index. If your upper bound is 5 but you only drag to row 4, you miss the last term. Count the rows: the number of terms is (upper − lower + 1). For i=1 to 5 that is 5−1+1 = 5 rows. If the summand references the index in an exponent or a denominator, check each term against a hand calculation for the first and last values.

This method works identically in Google Sheets. The SUM function and cell references are the same.

SEQUENCE generates a list of index values in one step. Combine it with SUM, and you can evaluate a sigma notation sum in a single cell. This is the method to use once you trust your summand formula.

Syntax for SEQUENCE

Microsoft Support defines SEQUENCE as: SEQUENCE(rows, [columns], [start], [step]). For a sum from i=1 to 10, you want a column of 10 rows starting at 1 with step 1. The formula is =SEQUENCE(10,1,1,1). If the lower bound is 3 and the upper bound is 12, that is 10 terms (12−3+1=10) starting at 3: =SEQUENCE(10,1,3,1).

Now nest SEQUENCE inside SUM with the summand formula wrapped around it. For Σ(i² + 1) from i=1 to 10 the single-cell formula is: =SUM(SEQUENCE(10,1,1,1)^2 + 1). The SEQUENCE returns an array of the ten index values. Each value is squared by the ^2 operator, then 1 is added. SUM adds the resulting array. The answer is 395.

Google Sheets supports SEQUENCE with the same syntax: SEQUENCE(rows, columns?, start?, step?). The Google Sheets function list confirms the identical four arguments. The same nested formula works: =SUM(SEQUENCE(10,1,1,1)^2 + 1).

The failure case: SEQUENCE does not exist in Excel versions before 2016. If the formula returns #NAME?, you are on an old version. Use the helper-column method or upgrade.

When the summand is a product of two expressions that each depend on the index, SUMPRODUCT is the cleanest tool. It multiplies corresponding elements of two arrays and then sums the products, the exact operation needed for Σ(aᵢ · bᵢ).

Example: Σ(i · (i+1)) from i=1 to 5

The term-by-term calculation: (1·2) + (2·3) + (3·4) + (4·5) + (5·6) = 2 + 6 + 12 + 20 + 30 = 70. With SUMPRODUCT: =SUMPRODUCT(SEQUENCE(5,1,1,1), SEQUENCE(5,1,1,1)+1). The first SEQUENCE generates 1,2,3,4,5. The second generates 2,3,4,5,6. SUMPRODUCT multiplies each pair and adds. The result is 70.

Microsoft Support documents SUMPRODUCT as: SUMPRODUCT(array1, [array2], ...). You can use it with two arrays or with three for triple products.

The failure case: SUMPRODUCT treats arrays as the same shape. If the two sequences have different row counts, SUMPRODUCT returns #VALUE! or an incorrect partial result. Always check that the SEQUENCE calls produce the same number of rows.

In Google Sheets the function is identical: SUMPRODUCT(array1, array2?). The Google Sheets function list shows the same syntax.

A common statistical mistake is confusing Σx² (sum of squares) with (Σx)² (square of the sum). SUMSQ exists specifically for Σx². Given a range or an array of numbers, it squares each value and adds the squares.

Example: Σ(i)² from i=1 to 4

The four terms: 1²=1, 2²=4, 3²=9, 4²=16. Sum = 30. With SUMSQ: =SUMSQ(SEQUENCE(4,1,1,1)). The SEQUENCE generates 1,2,3,4. SUMSQ squares each and sums them: 1+4+9+16=30.

Microsoft Support lists SUMSQ as: SUMSQ(number1, [number2], ...). The function accepts arrays and ranges.

The failure case: using =SUM(SEQUENCE(4,1,1,1)^2 for the same sum gives the same answer here, but SUMSQ is explicit. For readers familiar with sigma notation statistics, SUMSQ maps directly to the Σx² term in variance formulas. If you intend to use the result in a standard deviation calculation, remember that (Σx)² ÷ n is subtracted, not (Σx²) ÷ n.

Google Sheets does not have a dedicated SUMSQ function. Use =SUM(ARRAYFORMULA(SEQUENCE(4,1,1,1)^2)) or =SUM(SEQUENCE(4,1,1,1)^2) which Google Sheets evaluates as an array formula automatically.

Google Sheets and Excel share the core summation workflow but differ in three ways that matter for sigma notation.

SEQUENCE works identically in both. The syntax SEQUENCE(rows, columns?, start?, step?) from the Google Sheets function list is the same as Microsoft Support's definition. The one-cell method from earlier, =SUM(SEQUENCE(10,1,1,1)^2 + 1), runs without changes.

SUMPRODUCT works identically. The same formula from the Σxy section produces the same result in Google Sheets.

SUMSQ does not exist in Google Sheets. Use =SUM(ARRAYFORMULA(range^2)) or the simpler =SUM(range^2) which Google Sheets now treats as an array operation in most contexts. For Σx² from a helper column of values in A1:A10, the formula is =SUM(ARRAYFORMULA(A1:A10^2)).

The failure case: older Google Sheets documents or those imported from Excel may require explicit ARRAYFORMULA wrapping for exponentiation inside SUM. If the result is a single number that is clearly wrong (e.g., 4 instead of 30 for the 1-to-4 squares), wrap the array part in ARRAYFORMULA.

There is no single best method for evaluating sigma notation in Excel. The choice depends on the summand complexity and what you plan to do with the result.

• Helper column, Use when you need to see every term. This is the method for verifying a hand calculation or teaching someone what Σ means. It is also the only method that works on Excel versions before 2016 that lack SEQUENCE.
• SEQUENCE + SUM, Use for a simple summand with one index variable. This is the fastest method for one-off calculations. It fails when the summand requires conditional logic or nonlinear index steps that SEQUENCE cannot produce.
• SUMPRODUCT, Use when the summand is a product of two or more index-dependent expressions. This maps directly to Σ(aᵢ · bᵢ) forms common in statistics and physics.
• SUMSQ, Use only when the summand is exactly the square of the index and you are working in Excel. In Google Sheets, use the array-exponentiation form instead.

The honest caveat: none of these methods handles sums where the index variable appears inside a function like Σ sin(i) or Σ 2ⁱ without you building the full term array first. Those sums require a helper column or a custom Lambda function, which is a separate topic.

Method	One Cell?	Shows All Terms?	Works in Google Sheets?	Best For
Helper column	No	Yes	Yes	Learning, verification, complex summands
SEQUENCE + SUM	Yes	No	Yes	Simple sums, single-step calculation
SUMPRODUCT	Yes	No	Yes	Sum of products, Σ(aᵢ · bᵢ)
SUMSQ	Yes	No	No (use array form)	Σx² in statistics