View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
steve steve is offline
external usenet poster
 
Posts: 576
Default Auto Word Count for Excel

John,

This sounds like a worksheet function question. But...
Type your word in cell A1 and put this formula in cell B1
=COUNTIF(A2:IV65536,A1)

This looks at all cells except for the first row.

Excel shortened it to
=COUNTIF(2:65536,A1)
because I set it to look at all columns and now it looks at all rows except
for the first row.

Try it out...

--
sb
"John Mo" wrote in message
...
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