I found a solution! On can see it in the following uploaded file.
BetweenTwoNumbers.ods
<http://nabble.documentfoundation.org/file/n4061578/BetweenTwoNumbers.ods>
The function is:
=SUMIF('Num 1'.A1;">20";'Num 1'.A1)-SUMIF('Num 1'.A1;">60";'Num
1'.A1)+SUMIF('Num 2'.A1;">20";'Num 2'.A1)-SUMIF('Num 2'.A1;">60";'Num
2'.A1)+SUMIF('Num 3'.A1;">20";'Num 3'.A1)-SUMIF('Num 3'.A1;">60";'Num 3'.A1)
Is there a simpler way to do it?
-----
Best Regards from
Pál
--
View this message in context:
http://nabble.documentfoundation.org/Searching-numbers-between-two-values-tp4061491p4061578.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
