Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Create Named Excel Formulas

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 LicenseYou 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 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