I am excited about this webinar recording because it covers my favorite Excel function. SUMPRODUCT is the Swiss Army knife of functions. It can sum, count and perform criteria-based calculations that normally require special array formulas. The SUMIF and SUMIFS functions have two important limitations that SUMPRODUCT doesn’t, discover what they are.
The session outcomes will include
- The limitations of the SUMIF and SUMIFS functions
- The limitations and advantages of the SUMPRODUCT function
- Explanation of the standard use of the SUMPRODUCT function
- Explanation of undocumented techniques of the SUMPRODUCT function
- How to create powerful multi-criteria calculations without an array formula
- Learn about array syntax and how you can use it with SUMPRODUCT
- Discover how you can use INDEX, OFFSET and other functions with SUMPRODUCT
- How to perform 2-D summing calculations
Level: Intermediate
Duration: 1.5 hours
Price: AU$25