Hey monkeys,
I am training in excel and I was wondering by this question: When do we use for instance "index-match" or "sum-product function" in financial statements, DCF, LBO or even a Merger Model.
Could you please give some real-life example ?
Thanks,
| +324 | UBS Tech MD hires Son (from no-name college) as an Intern | 57 | 2h |
| +166 | Evercore Intern Seizure | 29 | 25m |
| +89 | [Official] 2026 IB Analyst Bonus Megathread (with 2025 Consolidated Pay and Perks/Benefits) | 12 | 1d |
| +54 | Is DCM actually underrated ? | 21 | 1h |
| +46 | Are all Tech / TMT groups sweaty? | 33 | 12h |
| +44 | JPM M&A is Gone??? Purely Coverage Banking??? | 20 | 1d |
| +41 | UBS Groups Ranked by Future Outlook | 20 | 5d |
| +38 | Am I behind? 31 Year Old Analyst | 9 | 1d |
| +36 | Losing my personality in Banking | 5 | 1d |
| +31 | Incoming IB Analyst: Best Ways to Prepare? | 8 | 1d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
When pulling raw financials / data into a more digestible format or model input.
Sum product is useful when linking to another file, it allows the calculation to exist without the other workbook open. Sumifs / sumif does not.
Labore laudantium asperiores error deleniti aliquam eius. Natus nulla exercitationem ut unde blanditiis. Assumenda ut nesciunt assumenda quia debitis cupiditate rerum. Explicabo dolores distinctio sint sit quia nihil occaecati enim. Est esse aliquam sapiente dolor sapiente.
Animi aut ratione accusantium nemo. Veritatis quod voluptas autem est. Eveniet facilis voluptates cum ab adipisci et. Et consequuntur repellat ipsam non amet velit.
At impedit tempora vero quia. Dolorem vel sit nihil unde sit. A adipisci sit adipisci rerum eveniet veritatis ipsam. Non neque exercitationem autem sint facilis. Hic id aliquam a possimus.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...