How do I make an excel function that counts words?

Question

Column A has names of people and the column B through F are titled by years and the data under show what level of award the people in column A won in that year (GOLD,SILVER,BRONZE).

I need a quick formula that will count how many gold/silver/bronze each has won total. Thank you very in advanced...

Correction I need 3 formulas, 1 to count gold, 1 silver and 1 bronze

Answer 1

Example 4: Counting the Number of Words Separated by a Space in a Cell
To count the number of words in a cell where the words are separated by a space character, follow these steps: 1. Start Excel, and then open a new workbook.
2. Type the following on sheet1:
A1: The car drove fast
A2: =IF(LEN(TRIM(A1))=0,0,LEN(TRIM(A1))-LEN(SUBSTITUTE(A1," ",""))+1)
The formula in cell A2 returns a value of 4 to reflect that the string contains four words separated by spaces. If words are separated by multiple spaces or if words start or end in a space, it does not matter. The TRIM function removes extra space characters and starting and ending space characters in the text of the cell.

In Excel, you can also use a macro to count the occurrences of a specific character in a cell, or range of cells.

Answer 2

You can build a pivot table or you can simply filter. On the menu click on DATA then SORT then use count formula. For pivot table highlight your data and click pivot table.

Answer 3

Use the COUNTIF function, this will count cells which meet a paricular condition:

=COUNTIF(B:B,"=Gold")
=COUNTIF(B:B,"=Silver")
=COUNTIF(B:B,"=Bronze")

Then repeat this for each of the columns. That should do the trick.

Answer 4

i'm uncertain if there's a formula in this. one way of counting letters is to click "Edit", then click "replace", interior the "locate what" container, form the letter you prefer to count selection, then bypass away the "replace with" container empty, then click "replace All". it is going to teach what number letters are replaced. For a chosen selection, go with the cells and repeat the above.

Answer 5

Here's the formula to enter: =hlookup(round(ab,0,5%+25),b1:b28)

Answer 6

use the count if function.....

=+COUNTIF($D$13:$D$721,"gold")

i just pasted this from my spreadsheet, and put in gold, but it should work if i understand correctly

THIS WILL WORK

Answer 7

Use the count or countA function