For inserting the Total Row, first, select any cell of the table and in the Design tab, select the Total Row under the Table Style option. When you have a data table in your worksheet you can insert the Total Row option for summing up the data in a table. Suppose the example that we are working on is now defined as a table in the worksheet. Summing Data in a Table using Total Row in Excel If you use this formula in the same row it will give a “0” result. Note: Like before you can’t use this formula in the defined row range of the formula as it will create the circular cell reference. The usefulness of using this formula is that, whenever you will place new products name along with the sales value, it will get updated automatically if the new values are in this column range.Īfter pressing Enter you will get the below result. This will sum up all the values of columns B, C and D. Type the formula =SUM($B:$D) in cell F11. Here the months are defined in sales B, C and D. Let`s say we want to find out the total sales of the products for the last 3 months.
You can add multiple columns by specifying the columns name instead of cells range. Now drag down the formulated cell downwards or double-click on the Fill handle to find out the totals sales of the other products.įinding Total by Defining Columns Range Instead of Cells Range.To calculate the total sales amount of hair dryer, type the formula =SUM(B2: D2) in cell E2.
In this case, we will be using the same formula but the calculation will be done in row-wise. Now let`s say you want to find out the total sales of the specific product.
Using the SUM/SUMPRODUCT Function for Multiple Rows Instead of SUM function, you can also use the SUMPRODUCT function to perform this calculation. Now after pressing Enter, drag this formulated cell in cell C10 and D10 to calculate the total sales for the month of February and March. Instead of using the AutoSum feature you can also use the SUM function directly to calculate the total sales for a month. Using the SUM/SUMPRODUCT Function for Multiple Columns Note: Instead of using the Autosum feature from Formulas tab, you can also use the keyboard shortcut “Alt+=”.