USING MICROSOFT EXCEL
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=SUM
|
|
|
=DATE
|
|
|
= HLOOKUP
|
|
|
=AVERAGE
|
|
|
=COUNTIF
|
Detailed explanation-1: -If you want to learn how to count text in Excel, you need to use function COUNTIF with the criteria defined using wildcard *, with the formula: =COUNTIF(range; "*") . Range is defined cell range where you want to count the text in Excel and wildcard * is criteria for all text occurrences in the defined range.
Detailed explanation-2: -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.
Detailed explanation-3: -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. In its simplest form, COUNTIF says: =COUNTIF(Where do you want to look?, What do you want to look for?)