In Excel, if you need to do a quick sum of a column of data that is too long, there are several ways to achieve it:
Autosum: Select the blank cell below the value you want to sum, and then click the Autosum" ( button. Excel will automatically try to select the contiguous numeric range above to sum it. After confirming that the range is correct, press the Enter key.
Enter the formula: Enter =sum(( in the target cell, and then drag with mouse to select the range of cells you want to ask for. When you're done making your selection, close the brackets and press Enter. For example, =sum(a1:a100) sums the data from rows 1 to 100 in column a.
If you often need to sum the same range, you can define a name for the range, so that you can directly use the name instead of the cell range when using the formula.
Define a name: Select the region you want to ask for, then enter a name, such as "salesdata", in the name box in the upper left corner, and press enter.
Sum by name: Enter =sum(salesdata) in any cell and press Enter.
Use shortcut keys: select the next cell of the cell range you want to sum (i.e. the first empty cell immediately below the numeric range), and press alt+= (equal sign), excel will automatically generate the summing formula. After that, press the Enter key to complete the operation.
For quickly viewing the sum of one or more columns (without putting the result in a cell), you can simply select the cells that need to be summed, and then view the "Sum" result on the status bar at the bottom of the excel window.
Make sure that the data in the summation range is formatted correctly to avoid ignoring numbers in text format.
If the data contains an error value, such as div 0!), the summation formula will return an error. You may need to deal with these error values first.
The above are several ways to quickly sum long column data in Excel. Choose the method that best suits your current needs to be more efficient.