Software Search Loading...

Create Named Excel Formulas

BUY | Excel Named Range Add-in Manager Start

Named Formulas can be used to create your own custom functions. Once created, they save you having to re-enter the formula name, correct formula syntax, parenthesis and formula reference range over-and-over. The functions you can choose from are: AVERAGE, COUNT, COUNTA, COUNTBLANK, MAX, MIN and SUM.

You can choose a Function and have that Function calculate the Formula Range relative to the Relative Cell. For example, if you choose SUM and the Formula Range A1:A10, the Relative Cell A11 and the Name MySum, you can then use: =MySum anywhere on row 11 on the chosen Worksheets. The result will be the SUM of rows 1:10 of the column the Named Formula resides in.

30 Day Money Back Guarantee On All Excel Add-ins! Big Discount for Unlimited License

You will be able to download your Excel Add-in immediately after ordering.

Excel Named Range Add-in Manager Start

Excel Named Range Manager 30 Day Money Back Guarantee Excel 97 through to 2003 Compatible. Payment Problems/Options SAVE by buying as part of a Add-ins collection
Order Type:

See Also: Excel Duplication Manager Add-in | Excel Formula Manager Add-in | Excel Number Manager Add-in | Excel Text Manager | Excel OzGrid Plus Add-in | Excel Time Sheet | Excel Time Wage and Pay book