On Sep 5, 1:21 pm, wrote:

Mr. OssieMac

Thank you for responding to the query.

My concern is that named ranges (created in Define Name space) should
reflect the prevalent states of the worksheet when the corresponding
columns or rows are inserted or deleted thereof.

In this case, the interaction linkage between worksheet and Define
Name space is akin to Swiss Cheese ; there are holes in the whole
thingy and hence weakening the interaction process.

Would like to add that,

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

Since the given ranges of the above formula do not reflect the
prevalent states of the worksheet when the corresponding columns (such
as would be taking place within the Range of E$2:E6) are inserted or
deleted thereof,

Consequently, TitleCount would not compute correctly.

Is there any alternative means to work around this difficulty ?

Please share your experience.

Regards.