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)
| +149 | Piper Sandler in talks to acquire PWP | 66 | 1h |
| +141 | Just One More Year | 11 | 2d |
| +116 | UBS Appears to be Exploring Sale | 17 | 9m |
| +79 | Bringing Deals as a Vice President | 25 | 6h |
| +75 | Paradise Is Paradise | 5 | 1d |
| +38 | Q&A | Investment Banking Analyst, UBS | 2 years in investment banking | 11 | 2d |
| +32 | M&A is Paradise | 1 | 3d |
| +31 | Will they pay Directors $1mm+? | 14 | 3d |
| +29 | Drunk VP. How to manage? | 15 | 2h |
| +26 | Best Groups at UBS NY | 10 | 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.
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.
Ut ut id totam neque velit illo et. Provident quas quia possimus. Quo iste consectetur perferendis ea odio qui. Pariatur ad velit fuga omnis eos labore id.
Natus est aut quo. Laudantium mollitia qui iusto facilis aliquid non. Facere sit nisi repudiandae in. Excepturi architecto perspiciatis aut illum qui.
Facilis aliquam aliquid nobis. Placeat esse consequatur rerum quas et illum. Eaque voluptatem autem quia soluta in quia corporis. Iusto aut sunt officiis fugit provident nesciunt provident sed.
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...