Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referencing whole column
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referencing whole column
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referencing whole column
Thank you.
"Jim Thomlinson" wrote: 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referencing whole column
Well, it's slightly less typing to do =A1+B1 (6 characters) than =A:A
+B:B (8 characters). If you wanted to, though, you could define a named range "An" to cover A1:A10 and another named range "Bn" to cover B1:B10, then you could have a formula like: =An+Bn in C1 and copy this down. Hope this helps. Pete On Nov 23, 8:30 pm, 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula referencing a column - autofilling in a row ??? | Excel Discussion (Misc queries) | |||
Referencing a column across worksheets | Excel Worksheet Functions | |||
Relative column referencing within formulas | Excel Discussion (Misc queries) | |||
Return a value by referencing row and column labels? | Excel Discussion (Misc queries) | |||
Referencing previous column in COUNTIF | Excel Discussion (Misc queries) |