See why you must go out and buy Excel 2007. See a comparison amongst six (6) multiple conditioned formulas and find out which is fastest:
SUM and IF Array
SUMPRODUCT Using Multiply By 1
SUMPRODUCT Using Double Negative
SUM and IF Array formula for adding with multiple conditions (criteria) takes 375% times longer to calculate than the Excel 2007 SUMIFS function.
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).
Duration : 0:4:59