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" wrote in message
...
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