All of these are the input value.
(the above function as you can see some "." (dot), when you type the formula, Please ignore the dot. Otherwise it will not work.
A6, B6, C6, D6, E6, F6, G6, H6 are the output value.
I try to find out the sum in the A, B, C, D and E no column.
Ex: First of all, type the input value like image shown after that put the mouse cursor on the A6 no cell and type the formula like =SUM(A3:A5). You will get the desire value.
N.B: The formula of Sum1 and Sum2 are the same. Both are working. However, always try to use first one. Because it saves your time and more flexible.
As you can see, I try to find our Column no F is average like (4+3+2)/3=3. type the following formula on the cell no F6.
=AVERAGE(F3:F5)
MIN means minimum. Using this formula will find out the minimum value.Such as 3, 6, 4, Here the minimum input value is 3.
MAX means Maximum value. Using this formula will find out the Maximum value. Such as 9, 5, 6, Here the maximum input value is 9