John Barman wrote:
I have been trying to fathom out the way to count the number of times a specific word appears in a text only column, and show the result in another cell.
For a simple example: Say I have a long column (eg A2:A200) with the words of either RED WHITE or BLUE in the cells, How do I count the number of times RED appears and show the result in A1?
I thought the COUNTIF function would be appropriate, but cant get the Syntax right
I'll be grateful for any ideas
John Barman
Try
=COUNTIF(A2:A200;"red")
No spaces
WSP
--
OOo 2.0.1 – SeaMonkey 1.5a/1.0b (nightlies...) - Win XP sp2
==============================================
http://www.answersingenesis.org/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
