Hi Rob
Rob wrote > I just found 2 formats that seem to work: > COUNTIF(D$4:D4,"<>"&"") > > and also > COUNTIF(D$4:D4,"<>") > No clue why this works, but it does... > > Thanks for thinking with me, I really don't understand why it works but it does. I'm attaching a sample file in case someone finds this useful. COUNTIF.ods <http://nabble.documentfoundation.org/file/n4179920/COUNTIF.ods> Thank you for teaching me a new trick. This formula is going to be quite handy. Best regards, Pedro -- View this message in context: http://nabble.documentfoundation.org/Calc-How-to-count-selected-lines-tp4179893p4179920.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
