| =AVERAGE() | =AVERAGEIF() | =AVERAGEIFS() | =AVERAGEA() | =COUNT() |
| =COUNTA() | =COUNTBLANK() | =COUNTIF() | =COUNTIFS() | =MAX() |
| =MIN() | =DCOUNT() | =DCOUNTA() |
=AVERAGE()
This function calculate the avg. value of given numbers.
Syntax: =AVERAGE(number1, number2, ...)
Ex:
=AVERAGEIF()
This function calculate the avg. value of given numbers on a certain condition.
Syntax: =AVERAGEIF(range, criteria, [avg_range])
Ex:
=AVERAGEIFS()
This function calculate the avg. value of given numbers when more than one condition.
Syntax: =AVERAGEIFS(avg_range, criteria_range1, criteria1, ...)
Ex:
=AVERAGEA()
This function returns the avg. of given data including the text.
Syntax: =AVERAGEA(range)
Ex:
=COUNT()
This function count the no. of values of the given cell range or values.
Syntax: =count(value1, value2, ...)
Ex: =COUNT(4,3,5,4,"%","siku") >> Output: 4
=COUNTA()
This function count the no. and other character, alphabets and blanks.
Syntax: =COUNTA(value1, value2, ...)
Ex: =COUNTA(4,3,5,4," ","siku") >> Output: 6
=COUNTBLANK()
This function count only the blank cell form the given cell range or value.
Syntax: =COUNTBLANK(range)
Ex: =COUNTBLANK(A1:A5) >> Output: 1
| 20 |
| % |
| 48 |
| siku |
=COUNTIF()
This function count the no. of values based on a condition.
Syntax: =COUNTIF(range, criteria)
Ex: Count More than 50 values
=COUNTIFS()
This function count the no. of values based on more than one conditions.
Syntax: =COUNTIFS(range, criteria)
Ex: Apple sales more than 50.
=MAX()
This function returns the maximum value of the given number.
Syntax: =MAX(number1, number2, ...)
Ex: =MAX(54,32,5,8) >> Output: 54
=MIN()
This function returns the minimum value of the given number.
Syntax: =MIN(number1, number2, ...)
Ex: =MIN(54,32,5,8) >> Output: 5
##################### ADVANCE FUNCTIONS #########################
=DCOUNT()
This function count the value as per the condition put form the database. (Only for numbers)
Syntax: =DCOUNT(database, field, criteria)
Ex: Customizable data count form database
