Once you click Excel will automatically add the sum to the bottom of this list. Column C contains quarterly sales values here we have to simply specify the first and last cell in a range of cells to be added up. The SERIESSUM function calculates the sum of a power series based on the following formula.
This is an easy task what about if you want to show the summation symbol in the beside cell.
Type an equals sign the SUM function and the numbers you are adding surrounded by parenthesis. The input value to the power series. Sum_range OptionalThe actual cells to add if you want to add cells other than those specified in the range argument. In such a scenario we can use the SUMIF function to find out the sum of the amount related to a particular vegetable from a specific supplier.