Excel Forum
Similar Content
Best Lookup Formula in Excel - Index and Match
Tutorial: A lookup using INDEX and MATCH is like a VLOOKUP without the restrictions.  Index and Ma...
6 Useful INDEX MATCH Lookup Examples in Excel - Workbook Included
Tutorial: 6 Detailed examples of how to make and use Index/Match Lookup formulas and functions in E...
How to Use INDEX MATCH Lookups in Excel - Step-by-Step Guide
Tutorial: Step-by-Step guide to using INDEX/MATCH to create the most versatile and robust lookup fo...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



Excel Magic Trick 673: Varying Commission Rate Lookup Formula SUMPRODUCT Amazing Solution!!


See how to use the SUMPRODUCT formula to calculate commission amounts based on varying commission rates based on cumulative sales totals for each month. See an amazing formula from Dave Patton at the Mr Excel Message Board.

Download file: http://flightline.highline.edu/mgirvin/ExcelIsFun.htm





Got a Question? Ask it Here in the Forum.