ROLL
|
NAME
|
PHY
|
CHE
|
MATH
|
TOTAL
|
PER
|
AVG
|
MAX
|
MIN
|
COUNT
|
COUNTA
|
COUNTBLANK
|
1
|
RAJ
|
90
|
78
|
65
|
|
|
|
|
|
|
|
|
2
|
RAJ
|
78
|
90
|
87
|
|
|
|
|
|
|
|
|
3
|
MOHAN
|
56
|
78
|
89
|
|
|
|
|
|
|
|
|
Mathematical and Statistical
Function
Sum (): -It is a mathematical function
which is used to add numeric value of a range of cells.
Syntax:
- =sum(Range of cells)
Percentage: -It calculates the percentage
values of a range of cells.
Syntax: - =total cell address*Full marks/total marks
Average (): -It calculates the average value
of a numeric range of cells.
Syntax: - =Average(Range of cells)
Maximum: -It returns the largest value in
the range of cells.
Syntax: - =Max(Range of cells)
Minimum: -It returns the lowest value in
the range of cells.
Syntax: - =Min(Range of cells)
Count: -It counts the number of cells
which shows numeric value only.
Syntax: - =Count(Range of cells)
Counta: -It counts the numbers of cells
that are not empty in the specified range.
Syntax: - =Counta(Range
of cells)
Countblank: -It counts the empty cells in a
specified range of cells.
Syntax: - =Countblank(Range of cells)
Ex: - =Countblank(a1:d10)