Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


On 28/12/2011 at 15:18, Csanyi Pal <csanyipal@gmail.com> wrote:
 
I'm trying to sum only those values in a range that are in the same time
greater than 25 and lower or equal than 384.

How can I do that?

You can use extra column.

Let's say in column A you have some numbers.
In column B enter formula:
=IF(AND(A1>24;A1<=384);A1)
You see that little black square in lower right corner of cell border? When 
you hover it, your mouse pointer will change into cross. Just grab that square 
and drag it all way down column B to place where number in column A stops. 
This will copy formula from cell B1 to B{number}, changing it's reference 
number in column A.
Now you can simply use SUM function on column B.

One of disadvantages of this method is that AVERAGE function will not work 
correctly. If you need average, you can use something like this:
=SUM(B1:B12)/COUNTIF(B1:B12; ">0")

Hopefully there is simpler method someone will point out.
-- 
Best regards
Mirosław Zalewski

-- 
For unsubscribe instructions e-mail to: users+help@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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.