|
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 [email protected] 31 days after purchase date.
See Also: Excel Training Index Or, All Software
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