Mr. OssieMac,

1. What is the initial range of WorkArea prior to inserting columns?

Answer : WorkArea is defined an initial range of A2:G100 on the
WorkSheet

2. How many columns you insert? (Make up a number if it varies)

Answer : For the purpose of testing the given formula, I have inserted
merely 1 column (to the right of Column B) and thereof, the formula
fails to compute correctly (albeit it works fine prior to inserting
that column).

The named formula created in the Define Name space is repeated for
ease reference,

TitleCount = SUM(IF(MID(
OFFSET('Sheet1'!WorkArea,0,
COLUMNS('Sheet1'!A6:E6)-1,
ROWS(Sheet1'!E $2:E6),1),1,100)=
MID('Sheet1'!E6,1,100),1,0))

WorkArea is defined a range of A2:G100 on the WorkSheet. TitleCount is
applied in Cell B6.
May insert several more columns (to the right of Column B) as the need
arises.

3. What is the range of WorkArea after you insert the columns?

Answer : After inserting 1 column (to the right of Column B), WorkArea
expands by 1 column to follow suit (namely, A2:H100 just as would be
expected following the logical operations of Excel)

4. What range would you like WorkArea to be after inserting the
columns?

Answer : After inserting the columns (to the right of Column B),
WorkArea would consequently be, by incremental expansion, A2:H100 to
I100 to J100 to K100 etc.

Regards.