I want to do the following:
-
for the first row in Excel, create a formula with named range. say: A1=1, B1=3. Create named range A1:B1 called "amounts". cell C1=sum(amounts). this makes row1 very readable.
-
now row1 is one of many rows with data in col A and col B. So I want to fill the formula from C1 into C2, C3...C1000 and so on. So if A2=4, B2=5, I want C2=9. If I try to fill, cell C2 will also have =sum(amounts) so the value in C2 will be 4 not 9.
How to fix this?
Thanks for your help.