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: firstname.lastname@example.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