Re: [libreoffice-users] Calc

Le 07/09/2011 05:36, Michael D. Setzer II a écrit :
> On 6 Sep 2011 at 23:57, Klaus Friis Østergaard wrote:
>
> Date sent:              Tue, 6 Sep 2011 23:57:05 +0200
> Subject:                [libreoffice-users] Calc
> From:                   Klaus Friis Østergaard<farremosen@gmail.com>
> To:                     users@global.libreoffice.org
> Send reply to:          users@global.libreoffice.org
>
> > Seach criteria in SUM.IF
> >
> > I have a list:
> >
> > with two coloums:
> >
> > A        B
> > Type   Amount
> > a        1000
> > b         500
> > c         250
> > a         200
> > a         100
> > b         300
> > ...
> >
> > in real life with more than 50 types
> >
> > I want to make a table that summerizes the total amount of types.
> I did the following
> =DSUM($A$16:$B$22,"Amount",{"Type";"a"})
>
> Put your example headings and number in A16: B22, and then
> made the formula in another cell to the right and copied it down.
> Then just need to change the "a" to each of the other options.
>
>
> > I wanted to make a two coloum table again like this:
> >
> >
> > X        Y
> > Type   total_amount
> > a        1300
> > b         800
> > c         250
> >
> > I was trying to use sum.if function.
> >
> > but how do I make the criteria string in the sum.if Depending on the value
> > in coloum X
> >
> > a   =sum.if(A1:A10;"=a";B1:B10)  but this is static,
> >
> > how can I make this as an reference with CONCATENATE like =sum.if(A1:A10,
> > CONCATENATE('"=';TEXT(X2);'"');B1:B10 )
> >
> >
> >
> > --
> > Klaus F. Østergaard,<farremosen(at)gmail dot com>
> >
> > --
> > 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
>
> +----------------------------------------------------------+
>    Michael D. Setzer II -  Computer Science Instructor
>    Guam Community College  Computer Center
>    mailto:mikes@kuentos.guam.net
>    mailto:msetzerii@gmail.com
>    http://www.guam.net/home/mikes
>    Guam - Where America's Day Begins
>    G4L Disk Imaging Project maintainer
>    http://sourceforge.net/projects/g4l/
> +----------------------------------------------------------+
>
> http://setiathome.berkeley.edu (Original)
> Number of Seti Units Returned:  19,471
> Processing time:  32 years, 290 days, 12 hours, 58 minutes
> (Total Hours: 287,489)
>
> BOINC@HOME CREDITS
> SETI        11189934.576302   |   EINSTEIN     6468781.769851
> ROSETTA      3563786.501816   |   ABC          7931278.254331
Hello Michael,

I thik that the demo file downloadable by following that link may help you:

http://www.cijoint.fr/cjlink.php?file=cj201109/cijDu46Eko.ods

I use the sumif fonction to extract from a table the amounts categorised 
in column "G" and to create a subtable named budget to check my personal 
finance.

Hope to be helpfull/

Jacques CHAILLET

Sorry for my poor langage. (French native)


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