excell arrays

[Guest]

How do I add a column of values to a row of values using an array?
eg: B5+B3,B6+C3,B7+D3,B8+E3,B9+F3,B10+G3

 

[SteveG]

Tommy,

This should work for you.

=SUM(B5:B10+TRANSPOSE(B3:G3))

This is an array formula so commit with Ctrl-Shift-Enter.

HTH

Steve

 

[Ragdyer]

Try this:

=SUM(B5:B10,B3:G3)

 

[Guest]

Thanks Steve and Ragdyer, I feel I may have explained it wrong,
eg:

B C D E F G H
3 7 4 9
2 B2+C2 => 2+3 => 5
3 B3+D2 => 3+7 => 10
6 B4+E2 => 6+4 => 10
8 B5+F2 => 8+9 => 17

Really appreciating the help on this.

Tommy Tank

 

[Ragdyer]

Then try this:

=B2+INDEX($C$2:$X$2,ROWS($1:1))

And copy down.