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.


Comments

Popular posts from this blog

What is unit testing

What is Manual Testing

What is Black Box Testing