excell arrays
 

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

excell arrays
 

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


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=556644

excell arrays
 

Try this:

=SUM(B5:B10,B3:G3)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Tommy Tank" <Tommy wrote in message
...
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

excell arrays
 

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








"SteveG" wrote:


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


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=556644

excell arrays
 

Then try this:

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

And copy down.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Tommy Tank" wrote in message
...
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








"SteveG" wrote:


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


--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=556644