Re: [libreoffice-users] Searching numbers between two values

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