How To: Use the SUMPRODUCT function in Microsoft Excel

Use the SUMPRODUCT function in Microsoft Excel

Are you looking for a way to make your Microsoft Excel formulas more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the very first installment in his "Excel Formula Efficiency" series, you'll learn about the basics of Excel's SUMPRODUCT function — why some people use double negative and why other use times one.

Learn theses important points:

1. When using the SUMPRODUCT function and multiple criteria, see how multiplying by one is more flexible than the double negative.

2. When using the SUMPRODUCT function and multiple criteria, see how using double negative will not yield an error when text is in the data range but multiplying by one will yield an error (double negative can handle text).

3. When using the SUMPRODUCT function and multiple criteria, see how using double negative is sometimes faster than multiplying by one.

Learn how to speed up slow calculating spreadsheets with formulas that calculate faster. See many methods to speed up your spreadsheet, decrease the amount of time it takes for the formulas to calculate. In this video series you will see tricks for both Excel 2003 and Excel 2007. Many of the large formulas in this series involve multi-conditional multiple criteria calculations that slow down the spreadsheet (worksheet, workbook).

Want to master Microsoft Excel and take your work-from-home job prospects to the next level? Jump-start your career with our Premium A-to-Z Microsoft Excel Training Bundle from the new Gadget Hacks Shop and get lifetime access to more than 40 hours of Basic to Advanced instruction on functions, formula, tools, and more.

Buy Now (97% off) >

Our Best Phone Hacks

Gadget Hacks' tips — delivered daily.

Be the First to Comment

Share Your Thoughts

  • Hot
  • Latest