L

#### Legacy 108568

##### Guest

I am trying to sum individual rows or columns, which normally would be easy, eg sum(A1:A7).

I need a function like sum but entered as an array formula over a series of cells which returns the sum of the columns or rows which I am using it for.

ie

1 3 5 4 8 | ={sum(A1:E3)} <-- (i would like the result to be 21)

2 1 0 3 6 | ={sum(A1:E3)} <-- (i would like the result to be 12)

8 6 8 2 3 | ={sum(A1:E3)} <-- (i would like the result to be 27)

----------------

11 10 13 9 17 <---(also using an array formula to return column sums)

In this case the array formula would be entered in cells A4:E4 to sum columns or F1:F3 to get the sum of each column.

I have tried using all sorts of if statements and subtotal etc but can not work out how to get the results I need.

Any suggestions would be very much appreciated!