Software Search, Categories and Specials
Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by

Active DataXL - Download


AnalyserXL - Download


DownloaderXL - Download


Smart VBA - Download


TraderXL - Download

Tools for Excel Tables

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS


Excel Cell Math by Format

BUY |Tools for Excel Tables Start

  Cells math by format

Use this gainful tool to search all cells in a specific range with a particular background color and to do some math with the results.  If you wish, you can include the active cell in the target range so that the cells surrounding the active cell become the target range.

  • Click on the the Cell's Math By Format button in the toolbar.

  • Select the target range and the mathematical operation you wish to do:

  • Select the range containing the colors to be searched.

  • Decide which sheets contain the same range to be searched.

  • The results may be pasted either as values or as formulas.

  • Select the cell(s) you want to paste the results in.

Excel does not allow you to create formulas that contains too many characters.  If your results throws excessive characters then cells math by format will inform you, and it (optionally) lets you to paste the results of your operation as values. This is a good alternative.

Back to Tools for Excel Tables Start

Tools for Excel Tables    $99.95 Secure Payment Options

1 $89.95 USD
2 - 5 Licenses $79.95 USD
6 - 9 Licenses $72.50 USD
10+ Licenses $54.95 USD

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 [email protected] 31 days after purchase date.

See Also: Excel Add-ins Index & Excel Training Index & Excel Templates Index & Neural Network Software Index Trading Software Index & Charting Software Index Or, All Software

Instant Download and Money Back Guarantee on Most Software

Try out: Analyzer XL | Downloader XL | Smart VBA | Trader XL Pro (best value) | ConsoXL | MergeXL | O2OLAP for Excel | MORE>>

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