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

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

Try this:

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

RD

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

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
>
>

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>>
>>