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