[libreoffice-users] Re: Calc- How to count selected lines

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: users+unsubscribe@global.libreoffice.org
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