The Merge & Center feature/button in Excel may be useful in terms of formatting, but will cause all sorts of problems when trying to build formulas.

Instead, use the lesser-known Center Across Selection feature, which produces results that *look* exactly the same as merged cells, but without any of the drawbacks.

Additional Links:

Rockstar Excel website: https://rockstarexcel.com/

Newsletter for free tips on using Excel to make your life easier: https://rockstarexcel.com/newsletter/

Book a free consultation: https://rockstarexcel.com/book-a-free-discovery-session/

Videos on using absolute, relative, and mixed references to build complex spreadsheets extremely quickly:
Part 1: https://youtu.be/PrJF5cYKZhk
Part 2: https://youtu.be/hotGj69Qd-w

Please take the opportunity to connect and share this video with your friends and family if you find it useful.