I remember there’s a way that you can use find and replace to do following: =Sum(A1,B1)… to become =Sum(A1, B1:B1)… Not replacing “B1” with “B1:B1”, but replace a single cell reference to become a range cell reference. If anyone can please help and advise, thanks a lot in advance.