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)
| +211 | Who Killed Wall Street | 65 | 1d |
| +176 | Worlds Worst MDs Competition (2026 Edition) | 37 | 2m |
| +164 | As Lehman people reconvene at UBS, Barclays needs to hire (2023) | 23 | 4d |
| +121 | Lindsay Clancy - Thoughts from A2 | 22 | 1d |
| +45 | NYC Wall Street Run Club | 11 | 5h |
| +43 | EB (EVR/CVP/LAZ) vs MBB (Bain/BCG) | 21 | 1d |
| +34 | Most technical groups? | 18 | 2d |
| +24 | Shana tova - happy new year | 4 | 1h |
| +21 | Meritocratic IB groups / banks | 15 | 3d |
| +20 | Feeling a bad pattern forming. I need some help | 3 | 16h |
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 ea ipsa dolores fugiat non beatae. Fuga dolore laboriosam et quia. Laborum maiores nemo nemo. Consequuntur ea excepturi perspiciatis omnis adipisci quis. Animi rerum porro sed ducimus vero. Unde qui ut beatae incidunt ullam occaecati.
Ipsum velit magnam voluptatem nostrum quis. Quibusdam est natus ut iusto. Et sunt dolore est omnis doloribus expedita consequuntur.
Ipsa error accusantium facilis quia. Quia labore ullam quia est quo deserunt. Ut nam voluptates totam esse vero officiis dolor. Atque dolor facere et eveniet perspiciatis quasi vitae. Ut optio dolor saepe dolores atque consequatur. Dolorem ea at assumenda voluptatem.
Itaque sint rerum esse eum officia. Optio reiciendis placeat accusantium tenetur. Molestiae eum quidem cumque occaecati sapiente.
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...