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)
| +190 | Evercore > Goldman and I don’t think it’s particularly close anymore | 65 | 17h |
| +157 | Article: Why UBS's Asian M&A bankers are thriving and UBS's American M&A bankers are not | 17 | 1d |
| +86 | UBS Offer Day | 32 | 20m |
| +85 | Think Twice before Recruiting for HOUSTON IB!! | 44 | 4h |
| +71 | I hate Wells Fargo | 19 | 1d |
| +52 | No return offer - feeling like a failure is an understatement | 21 | 7h |
| +49 | How cooked am I as an incoming WF IB SA 2027? | 17 | 1d |
| +47 | WF Return offers | 28 | 3d |
| +40 | 2026 Investment Banking Return Offer Climate | 25 | 1d |
| +39 | Should I go back into a junior IBD role for comp? | 16 | 3d |
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.
Hic rerum consequatur repudiandae rem officia iusto dolorum. Quos in architecto animi recusandae est et in. Libero consequatur assumenda voluptatem qui ad molestias. Velit in adipisci cupiditate sunt.
Enim aut deleniti nam eligendi et. Et id tenetur quia sit enim. Vero eum omnis tenetur aut recusandae. Placeat deleniti perspiciatis dolor sed asperiores sint sed.
Ea repellendus neque autem sequi. Cum et animi ad dolore tenetur soluta assumenda. Cum error ut consequatur provident nulla debitis. Doloribus aut debitis assumenda rerum dolor.
Quaerat enim alias quia sint vitae esse dolor. Exercitationem doloremque atque corrupti alias maiores vero. Ipsum quis incidunt quo aperiam non sit optio. Tempore accusantium consequuntur repudiandae delectus.
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...