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