excel函数用法及注意事项（Usage and notice of Excel function）.docVIP

excel函数用法及注意事项（Usage and notice of Excel function） EXCEL function usage and precautions 1, the function name: SUM Conditions of use: all parameters and numerical calculation. Use the format: SUM (NO1, NO2......) Parameters: NO1, NO2...... Mean values calculated can be specific numerical reference cell (area), etc.. Application: as shown in Figure 1, enter the formula in cell D12: =SUM (D2:D11), after confirmation can be obtained by mathematics score. Figure 1: Note: if the parameter is an array or reference, only one number will be calculated. Empty cell, logic in an array or reference value,