At 06:25 14/06/2013 -0700, Csányi Pál wrote:
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
respectively ( one by one ) and there is a
fourth function that should 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))
Try:
=COUNTIF('Num 1'.A1:Z99;">20")-COUNTIF('Num 1'.A1:Z99;">=60")
=COUNTIF('Num 2'.A1:Z99;">20")-COUNTIF('Num 2'.A1:Z99;">=60")
=COUNTIF('Num 3'.A1:Z99;">20")-COUNTIF('Num 3'.A1:Z99;">=60")
moreover, I don't know how to create fourth function.
Easy:
=J1+J3+J5
(!)
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@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