You're performing calculations that require summations of large amounts of data (for example, for leastsquares curve fitting) and would like to use builtin functions that make such summation computations easy.
Use Excel's builtin summation functions
such as SUM
, SUMSQ
, SUMPRODUCT
, and SUMX2MY2
.
Excel includes several builtin functions that make performing summations of large (or small) amounts of data very easy. Perhaps the most common sum function is SUM
, which simply adds all values contained in a range of cells. For example, =SUM(B2:B24)
adds all the values contained in cells B2 to B24. The range of cells does not have to be contiguous either. For example, =SUM(B2:B24,C2:C24)
adds all the values contained in each cell range (you separate cell ranges with commas). You can even include explicit values like this =SUM(B2:B24,1)
. In this case, the values contained in the range plus the specified value, 1, are added.
Most of Excel's functions that take cell ranges or multiple values as arguments allow you to mix cell references and values, using commas as separators.
Table 71 contains a list with short descriptions of several of Excel's convenient summation functions.
Table 71. Common summation functions
Function 
Syntax 
Description 



Returns the sum of all given numbers, which may include cell ranges and explicit numbers. 


Adds ... 
No credit card required