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,
| +148 | ONLY THESE BANKS OR YOU STRUCK OUT | 38 | 13h |
| +111 | IB Energy Drink Tier List / Ranking | 73 | 1d |
| +61 | Firm Thinks I'm Lying About Offer | 19 | 16h |
| +53 | Indiana University Fraternity Pipelines | 32 | 13h |
| +51 | Feedback for internship first desk at IBD BB - personal fit, "don't be too confident" | 29 | 2d |
| +39 | Stay at Weak Dealflow Team or Lateral? | 12 | 21h |
| +36 | Rogo AI | 14 | 11h |
| +34 | Elite Boutique interview questions | 8 | 1d |
| +30 | Suspended for a Year | 11 | 14h |
| +23 | 1st Half 2026 (1H26) RX IB & RX Co. Rankings | 14 | 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.
Aliquid eveniet asperiores error incidunt. Est atque dolore autem quae aut.
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...