Forum Discussion
Solved
absolute references in Smart tables Excel
hi, i'm trying to make mix-reference formula in Smart table Excel and cannot find the way to fix a colunmn. i need an equivalent of this in Smart table: in col C: =sum($A3:B3), in col 😧 =sum($A3:C3)...
Riny_van_Eekelen yes, i mean Structured tables, thank you for the interesting link, but it doesn't assume formula copying: I need in the same raw in column C to sum cells from column A to B, in col D - sum from A to C (including B), but when I copy the formula from C to D I'm getting the sum of A and C, excuding B.