Operator

PYI

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

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