mweyand,
my message with the sample file should read:

insert column before C and the average will account for columns B through the previous column. The percentage will also take care of inserted coulmns.

modytrane