Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with formula
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with formula
Luke thank you for the help. your solution works great but it is not exactly
what I am looking for. Can you write a formula that includes the range in the formula so I dont want to have to preselect or name the range in the name manger box. If not, what you suggested works great. "Luke M" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|