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<farremo...@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+h...@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:mi...@kuentos.guam.net
mailto:msetze...@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+h...@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