Re: [libreoffice-users] Re: what is the alternative of countifs function in libreoffice?
Hi :) That sort of checking gets considerably faster as you begin to find the powers and limitations of the new thing. Also as you find faster and easier ways of checking. It is one reason why people are very resistant to change. Regards from Tom :) --- On Sun, 29/1/12, soumalya ray drsouma...@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 :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 unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Dr soumalya ray http://drsoumalya.blogspot.com drsouma...@gmail.com MBBS,MD(PGT-C.Medicine),Ex-HousePhysician(Medicine) Skype: som3776 | Twitter: @docbkp http://twitter.com/docbkp -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: what is the alternative of countifs function in libreoffice?
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 unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Dr soumalya ray http://drsoumalya.blogspot.com drsouma...@gmail.com MBBS,MD(PGT-C.Medicine),Ex-HousePhysician(Medicine) Skype: som3776 | Twitter: @docbkp http://twitter.com/docbkp -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: what is the alternative of countifs function in libreoffice?
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 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, you can not add the same function twice this way. The work-around for this is a duplicate of the original field in the source table. -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Dr soumalya ray http://drsoumalya.blogspot.com drsouma...@gmail.com MBBS,MD(PGT-C.Medicine),Ex-HousePhysician(Medicine) Skype: som3776 | Twitter: @docbkp http://twitter.com/docbkp -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: what is the alternative of countifs function in libreoffice?
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: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Dr soumalya ray http://drsoumalya.blogspot.com drsouma...@gmail.com MBBS,MD(PGT-C.Medicine),Ex-HousePhysician(Medicine) Skype: som3776 | Twitter: @docbkp http://twitter.com/docbkp -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: what is the alternative of countifs function in libreoffice?
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, On 25 January 2012 23:07, Andreas Säger ville...@t-online.de wrote: 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 pilot. For single values you may try SUMPRODUCT(condition1;**condition2;...) -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Dr soumalya ray http://drsoumalya.blogspot.com drsouma...@gmail.com MBBS,MD(PGT-C.Medicine),Ex-HousePhysician(Medicine) Skype: som3776 | Twitter: @docbkp http://twitter.com/docbkp -- For unsubscribe instructions e-mail to: users+h...@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