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

Hi :)
That link tries to download the Pdf version but this link lets you see all the chapters and doesn't 
try to download anything until after you have had a look around at what you might be downloading
http://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Calc_Guide

I dunno why but some people get furious about links that force a download!  The single chapter is 
pretty tiny file-size but i guess some people have very restricted limits and of course some people 
just enjoy getting angry about anything.  
Regards from
Tom :)


--- On Wed, 25/1/12, Stefan Weigel <stefan.weigel@bildungskreis.org> wrote:

From: Stefan Weigel <stefan.weigel@bildungskreis.org>
Subject: Re: [libreoffice-users] what is the alternative of countifs function in libreoffice?
To: users@global.libreoffice.org
Date: Wednesday, 25 January, 2012, 17:26

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.

Use DataPilot. (Chosse: Data → DataPilot → Start). Your problem is
exactly what it was invented for.

Here is the LibreOffice manual:
http://wiki.documentfoundation.org/images/5/52/0308CG3-DataPilot.pdf

:-)

Stefan

-- 
LibreOffice - Die Freiheit nehm' ich mir!

-- 
For unsubscribe instructions e-mail to: users+help@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+help@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