Hallo ,

I have columns A ,B, C. A and B have some formulas. so then it will show some values

Now in C column i write formula A+B ... but says Invalid Operation... Is it not possible add two columns which has formulas


  • Jason Duryea
    Jason Duryea ✭✭✭✭✭✭

    The formula needs the full cell reference, which should include the column name plus the row number.

    =[A]1 + [B]1

    or use @row to make it easier to use the the formula within a column formula.

    =A@row + B@row