Using Subtotals in Microsoft Excel; Applying multiple Subtotals to your Excel table; Convert your data into Excel table to get total for your column. If you often need to sum columns, you can convert your spreadsheet to Excel Table. This will simplify tot

How to sum rows in Excel. Similarly to totaling a column, you can sum a row in Excel by using the SUM function, or have AutoSum to insert the formula for you. For example, to add values in cells B2 to D2, use the following formula: =SUM(B2:D2) How to sum

Article Summary X. The easiest way to find the sum of a column or row of numbers is to use Excel’s AutoSum feature. Start by clicking the first empty cell below your data if summing a column, or the first empty cell next to your data if summing a row.