![]() I didn’t include the current day in my last post, but decided to make a slight change in the column D formula here. Excel provides the curly braces, confirming it’s an array formula. The multi-cell array formulas for columns D and E are:īoth formulas are entered by selecting their respective ranges, typing in the formula, without curly braces, and using Ctrl+Shift+Enter. ![]() The Cumulative Actual formula, in cell C2, summarizes the Actual data in the same manner.Īs an introduction to Array formulas, in my last post I added two columns. It summarizes the historical and current day’s Plan data. In the spreadsheet you see pictured, a single-cell array formula for the Cumulative Plan is located in cell B2. ![]() ![]() The Evaluate Formula dialog box helps by revealing array values Excel holds in internal memory. A Single-cell Array formula is powerful, yet can be hard to understand. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |