2013 Archives by date, by thread · List index

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