Need a hand if anyone is willing. How do I carry over a sum formula (from a different worksheet) from one cell to the adjacent cell, when the array being summed jumps 3 cells each period.
(cchanging monthly data on one worksheet into quarterly on the other)
| +261 | Earliest you can get fired | 56 | 8h |
| +250 | UBS’s M&A BANKERS ARE DOING TERRIBLY. $200M EXTRA IS BEING CUT | 47 | 1h |
| +228 | Investment Banking is Divine | 38 | 12h |
| +223 | Career Crossroads | 31 | 17h |
| +214 | US 2027 SA IB worried about background check | 52 | 23h |
| +206 | Analyst: Why is UBS IB doing worse than peers?, UBS CFO: No Comment | 41 | 10h |
| +203 | Another $115bn Mega deal for these banks. Congrats! | 44 | 36m |
| +110 | Is UBS really that bad? | 32 | 1h |
| +37 | Is Houston SA 28 recruiting already over? | 32 | 12h |
| +23 | Sweat Group 2026 Discussion | 24 | 12h |
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.
I would just link in the three cells to the new spreadsheet and do the sums there. It will be easier to audit later.
Started doing that, helps some but is just another obstacle when I need to reference quarterly cells from a different sheet and can't drag right.
Highlight all of the arrays, ctrl+t, then reference each separate array in the table with index match or vlookup.
Not sure if this helps at all since I can't see the spreadsheet.
Aut quod molestiae nesciunt cum incidunt rerum tenetur. Corporis architecto est minus ut ad. Ut voluptas quae praesentium rerum voluptatem et asperiores. Ut at sed aut distinctio itaque.
Ut fuga amet voluptatum unde consequatur numquam ea. Repellendus corrupti at voluptatem minima tempora sunt. Iure quo qui quasi ipsam architecto.
Illum voluptas accusamus in eos. Voluptas et est libero qui. Neque ea quibusdam non occaecati quia. Commodi veritatis aut accusantium minima vel sed hic. Sed et aut adipisci rem qui eligendi dolorum. Deleniti laudantium tenetur aliquam sed numquam aperiam et.
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...