View Single Post
 
Old 09-25-2018, 10:05 AM
MimiCush MimiCush is offline Windows 10 Office 2013
Novice
 
Join Date: Jan 2018
Posts: 29
MimiCush is on a distinguished road
Default

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.
Reply With Quote