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
