From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Working with array formulas more easily

Working with array formulas more easily - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Working with array formulas more easily

- [Dennis] If you work with Excel Array formulas, 2 you've gotten used to the idea of completing the formula 3 or the function by pressing Control + Shift + Enter, 4 but Excel is changing the way these kinds of formulas work. 5 Some of you maybe have not ever used the formulas at all, 6 so in this case, it'll just be something easier 7 that you might not have been alerted to. 8 In this particular worksheet here, 9 we've got totals here in column D based on the information 10 to the left and a grand total at the bottom. 11 In some scenarios, 12 let's say we don't need these interim totals at all. 13 We just want the grand total. 14 What if we could somehow take all of these 15 times all of these and add them up? 16 If we were writing a formula, 17 we might try the following. 18 SUM, let's add up all of these times, all of these. 19 Now in older versions of Excel, 20 if you press Enter right now, 21 you'll get the VALUE popup…

Contents