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.
For those YTD formulas I think you want the COUNT on row 10 (the 2025 year), like this:
=SUM(B8:OFFSET(A8,0,COUNT(B10:M10)))