Pedro, In the 'derived' view in the second tab (example 2) the empty fields under heading Nr do contain a formula to display the number only if something is specified in the 'map' column in the main list (example 1). COUNTA also counts cells when they only contain a formula that returns an empty string. So, the effect is that it will count all cells. COUNT only counts cells containing numeric values I couldn't find how to use COUNTIF to do what I want. I always seem to have troibles with the formatting... I tried: COUNTIF(D$4:D4,"<> ") COUNTIF(D$4:D4,'<>" "') ## COUNTIF)D$4:D4,"<>''") ## string delimited with single quotes, inside total condition withing double quotes
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, Rob. On 30 mrt. 2016, at 17:29, Pedro wrote: > I'm not sure if this helps with any of your questions but COUNTA counts > numbers and/or text > > If you can provide a link to a sample file and explain what you expect maybe > it is easier. > > Pedro > > > > -- > View this message in context: > http://nabble.documentfoundation.org/Calc-How-to-count-selected-lines-tp4179893p4179898.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 > -- 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
