Hello WSP Many thanks for replying to my problem. The function works OK in the simple example of course. I had a little problem with the list that gave rise to my query. This was a long list of personal names that I had imported from another source. Using this same list in 1-2-3 I find the function works perfectly. By copying the list from 1-2-3 and pasting in OO it also works OK. So I have solved the problem, but without an explanation. The only difference between the two lists is that the original pasting in OO shows a little black triangle on the left of each cell, that I haven't a clue what it signifies!! and cant find anything on this in Help, FAQ's,etc John Barman
Message-ID: <[EMAIL PROTECTED]> Date: Sun, 22 Jan 2006 16:39:38 +0000 From: Wangshanpo <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] MIME-Version: 1.0 To: [email protected] Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 8bit Subject: Re: [users] Calc - Counting number of specified text entries in a column 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/
