I have an excel table with subtotals.

Some of the subtotals are not updating correctly. Others are!!

In the attached file:
Column [NetAmt2] is dependent on cell C5...named BKSTransUseDate.
Cell M209 holds the subtotal for column [NetAmt2]. It is not updating correctly when cell C5 is changed.

Column [Sh Obl2] is also dependent on cell C5... but it seems to be updating correctly.

I've built a data table in cells $I$216:$O$227 that is dependent on this subtotal being updated correctly when C5 changes.

I know this isn't the cleanest example...but any help would be greatly appreciated.