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)

                                    Ex: -               =sum(c2:e2)

 

Percentage: -It calculates the percentage values of a range of cells.

 

                                    Syntax: -       =total cell address*Full marks/total marks

                                    Ex: -               =F2*100/300

 

Average (): -It calculates the average value of a numeric range of cells.

 

                                    Syntax: -       =Average(Range of cells)

                                    Ex: -               =Average(c2:e2)

 

Maximum: -It returns the largest value in the range of cells.

 

                                    Syntax: -       =Max(Range of cells)

                                    Ex: -               =Max(c2:e2)

 

Minimum: -It returns the lowest value in the range of cells.

 

                                    Syntax: -       =Min(Range of cells)

                                    Ex: -               =Min(c2:e2)

 

Count: -It counts the number of cells which shows numeric value only.

 

                                    Syntax: -       =Count(Range of cells)

                                    Ex: -               =Count(a1:f10)

 

Counta: -It counts the numbers of cells that are not empty in the specified range.

 

                                    Syntax: -        =Counta(Range of cells)

                                    Ex: -               =Counta(a1:f10)

 

Countblank: -It counts the empty cells in a specified range of cells.

 

                                    Syntax: -       =Countblank(Range of cells)

                                    Ex: -               =Countblank(a1:d10)