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 LicenseYou will be able to download your Excel Add-in immediately after ordering.
Excel Named Range Manager
30 Day Money Back Guarantee Excel 97 or above.
Secure Payment OptionsSAVE
by buying as part of a
Add-ins
collection
| Order Type: |
|
Special ! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.
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
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft
GIVE YOURSELF OR YOUR COMPANY 24/7 MICROSOFT EXCEL SUPPORT & QUESTIONS