Thank you!
This method worked perfectly for me. I also manually did the worksheet myself using the instructions from publication 936, calculating the average mortgage balance using several of the methods they suggest (which is exactly what you also said) and I got the same deduction in Turbotax using your method.
In my case, I sold a home in 2021 that had a mortgage from 2016 with a balance over $1,000,000, and then purchased another home in 2021 that had a mortgage over $750,000. Thus the complications start.
