Sum All Matches with VLOOKUP in Excel (3 Easy Ways)įinding Total by Defining Columns Range Instead of Cells Range.How to Use VLOOKUP with SUM Function in Excel (6 Methods).SUM Ignore N/A in Excel( 7 Easiest Ways).How to Sum Colored Cells in Excel Without VBA (7 Ways).How to Sum Colored Cells in Excel (4 Ways).Read More: How to Sum Multiple Rows in Excel (4 Quick Ways) Now drag down the formulated cell downwards or double-click on the Fill handle to find out the totals sales of the other products.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. Read More: How to Sum a Column in Excel (6 Methods) 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+=”.

How to add multiple rows in excel 2013