Forum Discussion
Solved
Excel formula issue - YTD comparison with function Offset
Hi Expertise, I have a problem needed your help. The following table with 2.5 year data from Jan 2023 to Jun 2025. The table with formula (sum & offset) to calculate the YTD of each year. When I a...
Following m_tarler​ 's suggestion, perhaps in N7:
=SUM(B7:OFFSET(A7,0,COUNT(B$9:M$9)))
or
=SUM(OFFSET(B7, 0, 0, 1, COUNT(B$9:M$9)))
Fill down from N7 to N9.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
Hi Hans, please ignore the previous sample file. Please use this v2. Sorry for any inconvenience caused
Following m_tarler​ 's suggestion, perhaps in N7:
=SUM(B7:OFFSET(A7,0,COUNT(B$9:M$9)))
or
=SUM(OFFSET(B7, 0, 0, 1, COUNT(B$9:M$9)))
Fill down from N7 to N9.
Hi Hans, Thanks for your help again. Kindly find the sample file for your further study.
