A Single-cell Array formula is powerful, yet can be hard to understand. The Evaluate Formula dialog box helps by revealing array values Excel holds in internal memory.
In the spreadsheet you see pictured, a single-cell array formula for the Cumulative Plan is located in cell B2. It summarizes the historical and current day’s Plan data. The Cumulative Actual formula, in cell C2, summarizes the Actual data in the same manner.
As an introduction to Array formulas, in my last post I added two columns. The multi-cell array formulas for columns D and E are:
{=$A$2>=A5:A18}
{=D5:D18*B5:B18}
Both formulas are … Read the rest