Cell A1 is my "Total" column, with the formula of =sum(B1:X1). When I try to
add a new cell/column to the left of B1 (which then becomes B1, and B1
becomes C1, etc.), the formula does not include the new B1, but instead
changes to =sum(C1:X1). I have tried using =sum($B1:X1) but that didn't work.

I'd appreciate any insight as to how I can add a new cell/column to the left
of the existing first cell/column (i.e., B1) and have the formula adjust to
include the new cell/column.

I hope that makes sense. Thank you in advance!