Similar Content
Excel Formulas Won't Update
Tutorial: How to get your Excel formulas to update when you edit a worksheet. By default, each time...
Excel Formula to Get Domain Name from a URL
Tutorial: Two formulas that you can use to extract the domain name from a URL or to extract the sub-...
Formula to Delete the First or Last Word from a Cell in Excel
Tutorial: Excel formula to delete the first or last word from a cell. You can copy and paste the for...

# Excel Formula Efficiency 1: SUMPRODUCT function 12 Examples

Learn about the basics of SUMPRODUCT function and 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. The tricks you see are from a White Paper called Improving Performance in Excel 2007. 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).

Got a Question? Ask it Here in the Forum.