There's a secret class of formulas in which Excel will calculate many values and hold all of those values in the computer memory before summarizing the array of results.
Bill Jelen, CFO.com | US
December 8, 2010
Why not sumproduct? Easier to explain to colleagues, and easier for them to edit as well.
Posted by Jerome Kern | December 08, 2010 12:53 pm© CFO Publishing Corporation 2009. All rights reserved.