Excel will automatically display statistics mentioned above on the cell that the formula was entered. Take for example, values 2,4,6,8, and 5 fill up cells A1, A2,A3,A4,A5 correspondingly. If you put =SUM(A1:A5) in cell A6, you will have the sum of the values placed in the mentioned cells. This depends on the formula entered which may also be average, product, etc.
