Now, I have been asked to update my annual reallocation of costs by ADDING A NEW COLUMN of secondary revenue to the worksheet.

As soon as I enter a new column (in this case, column "D"), the CSE formula ceases to evaluate correctly. The new range should be (9:dz9), but the formula doesn't update automatically.

When I re-entered the CSE formula and identify the new range, the various rows do not always equate correctly. One of two (out of twenty) are correct, but the others are not.

I have spent the better part of today re-reading the various CSE posts and trying to update the formula, but to no avail.

Is there a trick for this type of operation (adding a column to the existing worksheet) that I am not catching on to that would make the CSE formula work all the time?

Sorry for the long post, but I thought it necessary to describe what I've been tried so far.

Thanks for any help.