Increment column by column from data row by row
try
=$A2+B2
instead.
In article , Jonah
wrote:
Can I increment a cell reference as I replicate data across a row. in
my example it just retains $B2 for all cell references.
e.g
A B C
D E
1 =A2+$B2 =A2+$B3 =A2+$B4
2 Andy Old
3 Peter Young
4 James Old
5 Mary Old
Jonah
|