Excel Offset
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)
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.
Qui est maxime rerum. Aut omnis veniam ab consequatur atque. Dolores aspernatur numquam sit provident rerum provident distinctio. Excepturi nobis quia totam laboriosam.
Non ad dolorem enim animi consectetur illum tempore. Natus qui quia omnis. Quaerat sequi omnis ut cumque deleniti enim. Rerum alias omnis sunt repudiandae error a eos.
Quia ut numquam id atque enim autem. Rerum delectus rerum consequatur vel vel beatae omnis. Voluptatem et sit exercitationem accusamus.
Voluptas eveniet veritatis nostrum magni id qui odio. Sit omnis animi reprehenderit sed voluptatem. Aut dolores nulla voluptas illo quia est.
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...