It acts similiarly to Excel's AVERAGE function. It simply calculates average of the given numbers.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
AVERAGE( number1, number2 = NA, number3 = NA, number4 = NA, number5 = NA, number6 = NA, number7 = NA, number8 = NA, number9 = NA, number10 = NA, number11 = NA, number12 = NA, number13 = NA, number14 = NA, number15 = NA, number16 = NA, number17 = NA, number18 = NA, number19 = NA, number20 = NA, number21 = NA, number22 = NA, number23 = NA, number24 = NA )
Give this function number, same goes for other number arguments as well, but they are optional.
As you can see in the example below, the average of numbers 10,20,30,40 is 25. By default excel removes NA values, by NA values I mean Excel's blank cells. Function will always return numeric class.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.