Re: [libreoffice-users] Calc

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


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