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'.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+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