Yes, the answer should be the same. C=A+B, E=sum(a,b)
F=max(a,b)
sum and max work correctly if I use A1, B1, etc but not when I use the name Col_1, Col_2. E & F sum and max the entire column not just one row.
That is why I wondered if there was something comparable to "@" to use "this" row.
|