Forum Discussion

AnaBoyko's avatar
AnaBoyko
Copper Contributor
Jan 20, 2021
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)...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Jan 20, 2021

    AnaBoyko 

    This works if you drag to the right, not copy/paste

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jan 20, 2021

AnaBoyko 

This works if you drag to the right, not copy/paste

AnaBoyko's avatar
AnaBoyko
Copper Contributor
Jan 20, 2021

SergeiBaklan thank you very much!, now I see my mistake: visually the rage and the cells sum are the same, the difference is only in commas in the formula - ":" or ";"

 

but I expected to see the range as we see in all other excel

 

 

 

 

 

 

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jan 20, 2021

    AnaBoyko 

    With semicolon that's another formula, with it you sum column A (fixed) WITH another column (C, D, etc). With colon you sum entire range from column A TO another column (C, D, etc).

    Just in case I attach the file with the sample.

Resources