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

[ramnarayan.k at gmail.com]

Hi

Just an additional solution for folks who want to count both numbers and
text in a series in open office calc

=COUNT(C1:C9) + COUNTIF(C1:C9,">*") seems to do the trick.

the first counts only number and the second counts only text entries and
both then get added up to give one figure
hope some one else finds this useful

regards
ram

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
>