Hi, I'm using LibreOffice 4.0.3.3 (Build az.: 400m0(Build:3)).
BetweenTwoNumbers.ods <http://nabble.documentfoundation.org/file/n4061491/BetweenTwoNumbers.ods> In the uploaded file BetweenTwoNumbers.ods there are four sheets: between 20-60, Num 1, Num 2, Num 3. On the 'between 20-60' sheet there are three functions to determine how many numbers can find on sheets Num 1, Num 2 and Num 3 respectivly ( one by one ) and there is a fourth function that sholud count that at once on all Num 1-3 sheets. As one can see, none of these three functions works: =COUNTIF('Num 1'.A1;AND('Num 1'.A1>20;'Num 1'.A1<60)) =COUNTIF('Num 2'.A3;AND('Num 2'.A3>20;'Num 2'.A3<60)) =COUNTIF('Num 3'.A5;AND('Num 3'.A5>20;'Num 3'.A5<60)) moreover, I don't know how to create fourth function. Can one advice me how to go further? ----- Best Regards from Pál -- View this message in context: http://nabble.documentfoundation.org/Searching-numbers-between-two-values-tp4061491.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
