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.
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.