Today I want to share my basic excel function exercise.
Target function: SUM, AVERAGE, COUNT, MAX and MIN.
Function script:
=SUM(number1;[number2];...)
=AVERAGE(number1;[number2];...)
=COUNT(value1;[value2];...)
=MAX(number1;[number2];...)
=MIN( number1;[number2];...)
Manual cell fill:
B12 : =SUM(b2:b11)
B13 : =COUNT(b2:b11)
B14 : =AVERAGE(b2:b11)
B15 : =MAX(b2:b11)
B16 : =MIN(b2:b11)
Result:
No comments:
Post a Comment