Question by  jokerscoat (27)

What is the excel function that will count the instances of a word?

I need help with excel.


Answer by  ahsanmahmoodawan (1169)

built-in functions can be used to perform calculations on spreadsheet data. while most of the people only use those funtions specific to there need there are many functions such as sum ,average ,max ,mix and if the if function that just about word so these are called excel function and and they will count instance of a word


Answer by  Munawer (365)

'Countif' function can be used to count the instances of a word granted that each cell contains exactly that word. For example, to count the word "hi" in multiple cells use following: =countif(cellrange, "hi")


Answer by  parnell257 (109)

= sum(LEN(range)-LEN(SUBSTITUTE(range, "text","")))/LEN("text"). In this function, you would replace range with the range of cells to be searched, in the format beginning_cell:ending_cell. You would replace text with the word you are searching for. = sum(LEN(a1:b23)-LEN(SUBSTITUTE(a1:b23,"mendel","")))/LEN("mendel") searches for mendel in cells a1 through b23.


Answer by  NarenMukherjee (308)

Find out how many times the word "OR" appears in cells B16:B4000 =(SUM(LEN(B16:B4000))-SUM(LEN(SUBSTITUTE(B16:B4000,"OR",))))/LEN("OR") It should be case sensitive. Press Control+Shift+Enter. Or =SUMPRODUCT((LEN(B16:B4000)-LEN(SUBSTITUTE(B16:B4000,C1,"")))/LEN(C1)) where B16:B4000 is the search range and c1 is the search string.


Answer by  Jack81 (10)

=dcount(database_range, column_name, criteria_range). Database_range = where your data are located with column headings. column_name = name of column where your "words" are located. Criteria_range = a 2 cell range containing column_name and under that the word you are locating. For example: =dcount(a1:d20, LastName, f1:f2). F1 contains LastName. F2 contains Smith.


Answer by  depika3 (156)

Excel document are spilt into more cells and available in more row and column and excel are mostly used to calculating and create table processing. And each cells are available in more charecters and as well as legnth of words are writtened by user at a time cells are elabrated.


Answer by  gigo (1706)

In Excel you have to write a VBA makro that goes over all cells and analyses the text of each cell. Count the similar words in a single cell by tokenizing the string.


Answer by  Heffer (122)

The function must be typed in all capital letters as it is case sensitive. This is the formula to insert by copy and pasting using shift, =(SUM(LEN(B16:B4000))-SUM(LEN(SUBSTITUTE(B16:B4000,"OR",))))/LEN("OR") . Where the word "OR" is where the word the user wants counted should be typed.

You have 50 words left!