DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
COUNT function
|
|
|
COUNTA function
|
|
|
COUNTIF function
|
|
|
COUNTBLANK function
|
|
|
Fungsi COUNTIFS
|
Detailed explanation-1: -The COUNT function counts the number of cells that contain numbers, and counts numbers within the list of arguments. Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers.
Detailed explanation-2: -Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list.
Detailed explanation-3: -The COUNTA function counts cells containing any type of information, including error values and empty text (""). For example, if the range contains a formula that returns an empty string, the COUNTA function counts that value.
Detailed explanation-4: -Type =COUNTIF( in the cell where you want to see the count. Select the range where you want to search for the text. Type a comma to go to the next argument and then type the text that should be in the cells you want to count.