Excel: Find Sum and Average

https://www.youtube.com/watch?v=kO094RKeQos

Sum

The SUM function, (math and trig function) adds values. You can add individual values, cell references or ranges or a mix of all three.

Syntax: SUM(number1,[number2],...)

• Number1    mandatory. The first number, cell reference, or range for which you want the Sum.


• Number2, ...    Optional. Additional numbers, cell references or ranges for which you want the Sum.

Average function returns the Average . It is (Arithmetic mean) of the arguments or values specified.

Syntax

AVERAGE(number1, [number2], ...)

• Number1    mandatory. The first number, cell reference, or range for which you want the average.


• Number2, ...    Optional. Additional numbers, cell references or ranges for which you want the average.

Notes:

• Arguments  can either be numbers or names, ranges, or cell references that contain numbers.


• Logical values and text representations of numbers that you type directly into the list of arguments are counted.


• If a range or cell reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included while counting average.


• Arguments that are error values or text that cannot be translated into number  will return errors.