Save the code and close the window, then type this formula =SumColumn(A1) (A1 is the first cell in the list column) into the first cell of list column, press Enter button, then the list except the header is summed up. Set pRng = ws.Range(ws.Cells(2, xIndex), ws.Cells(xRowIndex, xIndex)) XRowIndex = ws.Cells(Rows.Count, xIndex).End(xlUp).Row VBA: Extract number only Public Function SumColumn(pRng As Range) As Double In the pop-up window, click Insert > Module, then paste the following VBA code into the module. Select a cell of the column you want to select and press Alt + F11 to open the Microsoft Visual Basic for Applications window.Ģ. Using a Function also can sum the entire column except headers in Excel.ġ. Sum entire column except header use Function in Excel Tip: In Excel 2003, you can use this formula =SUM(A2:A655366). You can see the total of the list is summed up in the first cell and changes automatically as the list changes. In Excel 2007/2010/2013, type this formula =SUM(A2:A1048576) (A is the column you want to sum) into the first cell of your list, then press Enter button on the keyboard. In Excel, using a formula will be a good and easy choice for most Excel users.