Hi Guys,
I've been scratching my head over this one and the solution seems beyond my limited understanding of excel! Hoping someone can help.
So i have been working on using INDIRECT functions so i can use dynamic worksheets in a data set, this all seemed to be working nicely and i managed to get the formulas working until i tried to drag the formula across the table date range and the sumifs sum range did not update as i dragged the formula across, instead it has remained locked to the original range see attached (B$3:B$4) i would like the sum range to move with the formula to C$3:C$4..D$3:D$4...E$3:E$4...F$3:F$4...etc etc if that makes sense.
I have put together the attached to demonstrate the issue i am having.
Hopefully this is possible would be a real life saver if i can get this to work!
Thanks
Bookmarks