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

 SUMPRODUCT

The Excel SUMPRODUCT Formula

BUY | Excel Tips & Tricks Start

SUMPRODUCT

You find the SumProduct function powerful and versatile. However, you may have just scratched the surface. For example, you may be familiar with this kind of formula: {=SumProduct((Region="North")*(Month="Jan")*Sales)}.

Our workbook provides two examples where we put the function to work to solve much more complex problems.

Excel Tips & Tricks Start. > Find Your Excel VBA Procedure Quickly From Your Workbook Window & Alternatives to Excel Array Formulas & Sumproduct & Other Useful Regular Excel Formulas & Advanced Filter & Other Tips

Excel Tips & Tricks  $19.95 Secure Payment Options Instant Buy/Download 30 Day Money Back Guarantee

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