Excel summation formula can not only sum the numbers in a single column, but also sum the numbers in different columns. Enter "=sum (cell 1: cell 2, cell 3: cell 4, cell 5: cell 6)" in the cell where the result needs to be displayed. Where each "cell" is the cell in which the number requiring the sum is located. For example, to sum the numbers in columns A 1:A5 and C 1:C5, just enter "=sum(A 1:A5, C 1:C5)" in cell D65438, and Excel will automatically display the numbers of these two columns in D65438.
Besides Excel summation formula, Excel also has some other numerical statistical formulas, such as Excel COUNTIF and Excel average. These formulas are very commonly used in Excel and can be used for statistics and analysis of various numbers. Excel countif formula can be used to count the number of qualified numbers under certain conditions, and Excel average formula can be used to average some numbers. By using these formulas, users can easily carry out various digital analysis and report generation. At the same time, Excel also provides rich chart functions, which can visualize digital data and facilitate users to make better data analysis and decision.