One difference between Excal and Origin formuls is that in Excel, you would need to use A:A to refer to column A, while in Origin, A is used to refer to column A.

Formula with A:A, e.g. =average(A:A), etc. would not be recognized in Origin

In Origin 2026, it will be recognized and work so user doesn’t need to edit the formula.