[ubuntu-in] OT: Help in Openoffice (how to count text in series) - SOLVED

[Ramnarayan.K]

Hey sorry for the quick post and quick solving

the reply to my query is
countif(series,">.")

the key operator being >.

that seems to have done it nicely

ram

On Fri, Mar 6, 2009 at 11:43 AM, ramnarayan.k at gmail.com <
ramnarayan.k at gmail.com> wrote:

> Hi
>
> Am posting something related to openoffice ( have already posted to
> openoffice forum and done a google search, and am still to find a
> solution so am posting here as well, in case someone can help.
>
> Query is regarding counting random text in a series - i just need to
> know how many cells in a series have any text or number entry
>
> Eg i have rows with entries like NL1 NL2 till say NL 36
> another row with another set like LL1 to LL60 and then NIC1 NIC2 etc
>
> so each row has multiple text entries (not same)
>
> i need to do one thing basically - from a series find how many of the
> cells has any entry in them (text or numbers)
>
> to find how many have a particular text seems easy i use the funtion
> =COUNTIF(C19:C26,"FOO") and this seems to count the number of entries
> with foo
>
> but i want to know how to count for any random text
> have tried *.* , simply . etc no operator seems to work
>
> any ideas tips.
>
> I tried searching but have not got any positive links
>
> thanks
> ram
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://lists.ubuntu.com/archives/ubuntu-in/attachments/20090306/d648a33f/attachment.htm