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

Reply via email to