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 ramnaraya...@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 > -- ubuntu-in mailing list ubuntu-in@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-in