[libreoffice-users] Calc

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