Download Excel File: https://excelisfun.net/files/EMT1775.xlsx
Learn 3 formula methods to add the top three values.
Learn how to.
1. (00:00) Introduction
2. (00:12) Look at the issues that make this problem difficult
3. (00:59) 1st solution: SUM, LARGE and SEQUENCE solution
4. (01:10) 1st for if you don’t have Microsoft 365 Excel
5. (02:49) 2nd solution SUM and SMALL functions solution
6. (03:52) BYROW and LAMBDA functions solution to spill formula. Solution only works in Microsoft 365 Excel (Beta as of Feb 2022).
7. (05:44) Change input to change Top 3 to Top 4
8. (06:01) Summary
9. (06:11) Closing and Video Links