ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   help with formula (https://www.excelbanter.com/excel-discussion-misc-queries/229722-help-formula.html)

ManhattanRebel

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?

Luke M

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?


ManhattanRebel

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?



All times are GMT +1. The time now is 04:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com