auto total word occurences in sheet

  • Thread starter Thread starter johnmo
  • Start date Start date
J

johnmo

I want to display a total of the occurences of a
particular word entered into an Excel sheet, into a
specific cell. As the sheet is changed, and there are more
occurances of the word entered, i want a running total
displayed in this cell. Can anyone here help with this?
thanks
JMO
 
JMO,
You can use the countif function. This will work to the
extent that the relevent word is the ONLY thing in the
cell. For example, if you say [=countif(a:a,"test")] in a
given cell, then it will work for anything that
says "test" in column a, with no spaces after or before.
Also, "test one" would not register since it is not
exactly "test."

If there might be spaces in some cells from importing or
something, you can solve that problem with the "trim"
function, which takes off spaces before or after the text
string(i.e. [=trim(c4)] with c4s value being "test ",
would become "test")

hth,
Dave
 
Back
Top