Creating array from matrix with blank values

[Andryll.Davis]

I have a matrix in the following format

1 X X X X X X X X
X X X 3 X X X X X
4 X X X X X X X X

where 'X' is a blank cell.

I need to get the data in the form
1
3
4

Any suggestions? I tried a nested if statement but it doesn't work
since there are more than 7 ifs.

 

[Bernie Deitrick]

Andryll,

If there is only one value in each row, then simply using

=SUM(A1:L1)

where A1:L1 is your top row, then copied down for two more rows, will give you your desired result.

HTH,
Bernie
MS Excel MVP