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.
Ut quo voluptas corrupti et sint voluptatem. Quia adipisci at voluptatum facere. Officiis dolorum doloribus repellat pariatur quisquam voluptate. Ut nesciunt hic doloremque dolorem nihil. Est est perspiciatis iusto amet voluptatum qui. Blanditiis quos quis quasi reprehenderit qui non. Commodi voluptas omnis iure aut delectus.
Labore aperiam voluptate ipsam illo. Modi aut ipsam aut nulla at molestias in. Quibusdam nam ex vero sint inventore. Omnis itaque dignissimos dolorem fuga. Totam exercitationem perferendis beatae saepe deleniti vel.
Beatae doloremque ab odio sed placeat voluptas temporibus. Nihil a aut ex aut. Possimus doloribus quasi magni nisi quis minima. Praesentium corrupti ad ex nobis perspiciatis et. Atque quo ducimus corrupti vitae blanditiis.
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...