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 <[email protected]>
To: [email protected]
Send reply to: [email protected]
> 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: [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
>
+----------------------------------------------------------+
Michael D. Setzer II - Computer Science Instructor
Guam Community College Computer Center
mailto:[email protected]
mailto:[email protected]
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: [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
