Well, maybe not the *only* way:


A1: =SUM(INDIRECT("B1:C1"))

or

A1: =INDIRECT("B1") + C1

or whatever combination is desired.

In article ,
Gordon wrote:

And in fact that doesn't work either. :-)
The only way to do that is to do a Find and Replace after you have
inserted the column.