Thread: Assigning commonly used formulas a function name

I know this is possible because I've done it before, but google is not helping me out on this.

There is a way to save commonly used formulas as a command. For example, if I used sum(R6:R8) a lot either as a formula or as a part of a formula, I could save it as the function SR and then use that instead. Can someone remind me how to do this?

Thanks.

Hi Phil, my guess is you're referring to using a defined name. In 2003 I believe it's under Insert -> Name -> Define.

Call the name what you want, e.g. SR, and then change the "Refers to" box to a formula like:

=SUM(Sheet1!$R$6:$R$8)

You can then use =SR anywhere to refer to that SUM. If you want it to be relative to the cell you're in, and not always R6:R8, then just remove the $'s.

define a name
e.g
to sum sheet1 a2:a5
insert/name give it a name say "mysum"
then in refers to put
=SUM(Sheet1!$A$2:$A$5)

use as =mysum