Re: [libreoffice-users] To sum only those values in a range that are between two number

2011-12-28 Thread Regina Henschel
Hi, Csanyi Pal schrieb: Hi, 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? =SUMIF(range;"<=384") - SUMIF(range;"<=25") Kind regards Regina -- For unsubscribe instructions e-mail to: users+h...@global

Re: [libreoffice-users] To sum only those values in a range that are between two number

2011-12-28 Thread Mirosław Zalewski
On 28/12/2011 at 15:18, Csanyi Pal 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(

[libreoffice-users] To sum only those values in a range that are between two number

2011-12-28 Thread Csanyi Pal
Hi, 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? -- Regards, Pal -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lis