[libreoffice-users] Searching numbers between two values
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'.A120;'Num 1'.A160))
=COUNTIF('Num 2'.A3;AND('Num 2'.A320;'Num 2'.A360))
=COUNTIF('Num 3'.A5;AND('Num 3'.A520;'Num 3'.A560))
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: 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
Re: [libreoffice-users] Searching numbers between two values
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'.A120;'Num 1'.A160))
=COUNTIF('Num 2'.A3;AND('Num 2'.A320;'Num 2'.A360))
=COUNTIF('Num 3'.A5;AND('Num 3'.A520;'Num 3'.A560))
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
Re: [libreoffice-users] Searching numbers between two values
At 08:48 14/06/2013 -0700, Csányi Pál wrote:
Now I'm searching the way how to SUM those
numbers ( between 20 and 60 ) found on sheets Num1, Num2, Num 3?
BetweenTwoNumbers.ods
http://nabble.documentfoundation.org/file/n4061519/BetweenTwoNumbers.ods
I uploaded the file again, because I changed it
a little. I changed it because I search for a
function which I can put in to just one cell of the 'between 20-60' sheet.
Try:
=SUMIF('Num 1'.A1:Z99;20)-SUMIF('Num
1'.A1:Z99;=60)+SUMIF('Num
2'.A1:Z99;20)-SUMIF('Num
2'.A1:Z99;=60)+SUMIF('Num 3'.A1:Z99;20)-SUMIF('Num 3'.A1:Z99;=60)
There may be neater solutions!
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
