认为这将评估为所需数组，并可扩展到更大的范围：

= MMULT（A1：C4，TRANSPOSE（COLUMN（A1：C4 ）^ 0））

eg, we have

 1  2  4
 3  4  5
 4  5  5
 2  4  5

I would like a array formula that returns an ARRAY = {7,12,14,11} Note it is not text, it is an array can be used in other array formula.

Currently i am using {=A1:A4+B1:B4+C1:C4+D1:D4}, however if the number of column is huge I cannot handle it manually.

I think this evaluates to the required array and could be extended to larger ranges:

=MMULT(A1:C4,TRANSPOSE(COLUMN(A1:C4)^0))