cfo.com

cfo tagline

Spreadsheets: Many Formulas into One with a Top-Secret Move

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 array formula?

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.