There is no really compelling reason other than personal preference. I find
it easier to use A1+B1 as I find it a bit more clear, especially when you
have sheets with sumif, countif or array type formulas which reference entire
columns...
--
HTH...

Jim Thomlinson


"Christina" wrote:

Let's say there are numbers in cells A1:A10 and B1:B10 and you create a
simple formula to add two cells =A1+B1 and copy it down. Is there a
compelling reason to use specific cell references for something like this
rather than =A:A+B:B?