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
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
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
>>
>>
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks