Hi all
im trying to use a sum(offset(match combination
i have Jan - dec data and i want to be able to choose my starting month and ending month of the sum
so for example Feb - april or Jan to jan
I have successfully managed sum from Jan to any other month but the issue i have is Jan is the reference of the offset and i cant make it point to a dynamic cell
example the k$13 reference i cant make dynamic like i have with the width reference (there is a drop down to choose the month number)
=SUM(OFFSET(K$13,0,0,1,MATCH('MAN ACCOUNTS'!$Z$2,'Calculation tab'!K1:V1,0)))
im probably not explaining this well but im gonna try
Bookmarks