help with formula
Let's say you've labeled cells A2:A10 as "MyRange".
Simply write it in a formula as you would a cell reference
=SUM(MyRange)
You'll note that when you do this, XL will highlight the range just like it
would if you typed a cell reference.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"ManhattanRebel" wrote:
when entering a formula, how can i designate a range for it to automatically
apply to?
I know I can enter a range in the "name" field to the left of the formula
bar (and use CTRL - Enter), but i want to know how to place the range in the
formula itself. For example, when entering this formula =a1+3, where exactly
do I insert the range?
|