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