Sum Rows of an Array

[guybrown]

Hi

I have the array 1,1,0;0,1,0;0,1,0;1,0,0;1,0,0
Notice there are 5 sets of 3 numbers (5 rows, 3 columns)
I'd like to sum the rows to get 2;1;1;1;1

I would then like to conditionally concatentate text from cells:
A1 if first number in array is >0
A2 if second number in array is >0
A3 if third number in array is >0
etc

Is this possible? Formula preferred please.

Regards,

Guy
XL2007

 

[mikerickson]

Try
=REPT(A1,(SUM(INDEX(theArray,1,))>0)&REPT(A2,(SUM(INDEX(theArray,2,))>0)&REPT(A3,(SUM(INDEX(theArray,3,))>0)&REPT(A4,(SUM(INDEX(theArray,4,))>0)&REPT(A5,(SUM(INDEX(theArray,5,))>0)