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, [email protected] < [email protected]> 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 [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-in
