Re: Don't understand this format by T
T
Tue Jul 22 21:29:12 CDT 2008
>what is the purpose of having the range =B2:B12 + C2:C12
>when I just want to add B2 and C2
If you just want B2+C2 there is no reason to use the whole range. Why did
someone do it that way? I don't know!
Maybe they wanted the sum of each row but entered it as an array.
If you select the entire range D2:D12 then type in the formula and enter it
as an array** you'll get the sum of each row.
** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)
--
Biff
Microsoft Excel MVP
"Chewie" <Chewie@discussions.microsoft.com> wrote in message
news:826DD7A6-69A8-41D1-8031-1B12C3F302C7@microsoft.com...
> Yes - I meant B2 + C2. But what is the purpose of having the range
> =B2:B12 +
> C2:C12 when I just want to add B2 and C2. Is there any reason to include
> the
> range or is it wrong? If it is wrong, it still creates the correct answer.
> (I am reading this formula from a spreadsheet I did not create, but I need
> to
> understand it). Thanks again
>
> "T. Valko" wrote:
>
>> > The answer in D2 is simply =B2*C2
>>
>> Actually, the answer is B2+C2
>>
>> This is working because the formula is entered in D2 and it references
>> cells
>> that reside within an implicit intersection as it relates to cell D2. In
>> other words, it works because the referenced cells and the formula are
>> all
>> on the same row.
>>
>> Try entering the formula in D1 and see what happens.
>>
>> --
>> Biff
>> Microsoft Excel MVP
>>
>>
>> "Chewie" <Chewie@discussions.microsoft.com> wrote in message
>> news:1C465D1A-FD48-45C7-BA5F-EDD7EDC0FCF9@microsoft.com...
>> > Why does this work =B2:B12+C2:C12?
>> > The answer in D2 is simply =B2*C2 and even if I copy down, it only
>> > multiplies the first cells. My question is: What does a range signify
>> > when
>> > it is out of a function? It seems to do nothing.
>> > Thanks
>> >
>>
>>
>>