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.