FUNDAMENTALS OF COMPUTER

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: -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?)

Detailed explanation-3: -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-4: -Just click the column header. The status bar, in the lower-right corner of your Excel window, will tell you the row count. Do the same thing to count columns, but this time click the row selector at the left end of the row. If you select an entire row or column, Excel counts just the cells that contain data.