[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?

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 csanyi...@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

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: