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

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: 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


-- 
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