hi, is there any alternative for "countifs" function in libreoffice (not "countif")? 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.how to do it in libreoffice? in ms office 2010,there is this function- "countifs(criterion range 1,criterion 1,criterion range 2,criterion 2)" which could do this.could not find anything like this in libreoffice.is there any alternative? thanks in advance, regards,
-- Dr soumalya ray <http://drsoumalya.blogspot.com> <[email protected]> MBBS,MD(PGT-C.Medicine),Ex-HousePhysician(Medicine) Skype: som3776 | Twitter: @docbkp <http://twitter.com/docbkp> -- For unsubscribe instructions e-mail to: [email protected] 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
