That is one of the reasons why one should use merging ONLY for cosmetic purposes.
If merged cells contain formula or are referenced by one, they are nothing but trouble.
Merging should be avoided

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post