Re: [libreoffice-users] Re: what is the alternative of countifs function in libreoffice?

2012-01-29 Thread Tom Davies
...@gmail.com wrote: From: soumalya ray drsouma...@gmail.com Subject: Re: [libreoffice-users] Re: what is the alternative of countifs function in libreoffice? To: users@global.libreoffice.org Date: Sunday, 29 January, 2012, 7:27 yeah and then 10 min to check whether i made any mistake or not! :D

[libreoffice-users] Re: what is the alternative of countifs function in libreoffice?

2012-01-29 Thread Andreas Säger
Am 29.01.2012 08:27, soumalya ray wrote: yeah and then 10 min to check whether i made any mistake or not! :D :D regards, Since I know the usual navigation keys and fill methods with all the availlable keyboard shortcuts, I am always sure to do the right thing in *any* spreadsheet. Simply

[libreoffice-users] Re: what is the alternative of countifs function in libreoffice?

2012-01-29 Thread Pedro
Hi soumalya ray soumalya ray wrote yeah and then 10 min to check whether i made any mistake or not! :D :D This kind of answers will only cause people to stop helping you. One solution was given to you 2 days ago, and yet you don't want to waste 10 minutes. That shows how committed you are

[libreoffice-users] Re: what is the alternative of countifs function in libreoffice?

2012-01-28 Thread Andreas Säger
Am 28.01.2012 05:47, soumalya ray wrote: its really time consuming.is there any other way to achieve this? regards, 3 seconds. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting

Re: [libreoffice-users] Re: what is the alternative of countifs function in libreoffice?

2012-01-28 Thread soumalya ray
yeah and then 10 min to check whether i made any mistake or not! :D :D regards, On 29 January 2012 02:17, Andreas Säger ville...@t-online.de wrote: Am 28.01.2012 05:47, soumalya ray wrote: its really time consuming.is there any other way to achieve this? regards, 3 seconds. -- For

[libreoffice-users] Re: what is the alternative of countifs function in libreoffice?

2012-01-27 Thread Pedro
soumalya ray wrote now i am trying to include the row/column percentage into the data pilot result directly along with the absolute count.so far, no luck!! I guess you just bumped into the LO Pivot Table limitations (compared to MS Office) In MS Office you would just add again the same

[libreoffice-users] Re: what is the alternative of countifs function in libreoffice?

2012-01-27 Thread Andreas Säger
Am 27.01.2012 11:23, Pedro wrote: I'm almost sure that you can't do that in the LibreOffice Pivot Tables (unless there are some undocumented features that I'm not aware of? ) You can select multiple functions for the same data field. The function selector is a multi-select list box. Indeed,

Re: [libreoffice-users] Re: what is the alternative of countifs function in libreoffice?

2012-01-27 Thread soumalya ray
sorry;could not understand the meaning of 'duplicate the field'.could you explain a bit more please? regards, On 27 January 2012 17:05, Andreas Säger ville...@t-online.de wrote: Am 27.01.2012 11:23, Pedro wrote: I'm almost sure that you can't do that in the LibreOffice Pivot Tables (unless

[libreoffice-users] Re: what is the alternative of countifs function in libreoffice?

2012-01-27 Thread Andreas Säger
Am 27.01.2012 19:04, soumalya ray wrote: sorry;could not understand the meaning of 'duplicate the field'.could you explain a bit more please? regards, Create a calculated field with nothing but a reference to the field you need twice. -- For unsubscribe instructions e-mail to:

Re: [libreoffice-users] Re: what is the alternative of countifs function in libreoffice?

2012-01-27 Thread soumalya ray
its really time consuming.is there any other way to achieve this? regards, On 27 January 2012 23:57, Andreas Säger ville...@t-online.de wrote: Create a calculated field with nothing but a reference to the field you need twice. -- For unsubscribe instructions e-mail to:

Re: [libreoffice-users] Re: what is the alternative of countifs function in libreoffice?

2012-01-26 Thread soumalya ray
ok,data pilot works.i tried it earlier also but somehow missed the 'clicking data field and change the function' part.thanks for the link @stefan. @andreas, could not understand how to use sumproduct in my case.is it not a way of multiplication? in my case, i am trying to filter the data. regards,

[libreoffice-users] Re: what is the alternative of countifs function in libreoffice?

2012-01-26 Thread Andreas Säger
Am 26.01.2012 09:42, soumalya ray wrote: ok,data pilot works.i tried it earlier also but somehow missed the 'clicking data field and change the function' part.thanks for the link @stefan. @andreas, could not understand how to use sumproduct in my case.is it not a way of multiplication? in my

[libreoffice-users] Re: what is the alternative of countifs function in libreoffice?

2012-01-25 Thread Andreas Säger
Am 25.01.2012 18:26, Stefan Weigel wrote: Hi, Am 25.01.2012 17:16, schrieb soumalya ray: say,in one column gender of the participants are written (male/female).in next column height of the participant is written.now i want to count how many females have height=1.55 metre. +1 for the data