John

assuming the formula is in cell A1 and the word you are looking for is in
cell B1, you could use:

Cell A1 contains "=COUNTIF(A2:B65536,B1)+COUNTIF(C:IV,B1)" no quotes

or, if you want to include (count) the word you are looking for:

Cell A1 contains "=COUNTIF(A2:A65536,B1)+COUNTIF(B:IV,B1)" no quotes

Regards

Trevor


"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