"DVEINTIMILLA" wrote:
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.
[....]
Download: http://www.excelbanter.com/attachmen...tachmentid=712

Both M209 and N209 change when I change C5 from 12/20/12 to 6/1/12
arbitrarily. (I am making no effort to try to understand the logic of your
worksheet.)

Note that M209 has the formula =SUBTOTAL(109,[NetAmt2]) and N209 has the
formula =SUM([Sh Obl2]).

My guess is: __you__ change C5 (you neglect to give an example the
demonstrates how), it causes changes in some hidden cells in [NetAmt2], but
no non-hidden cells. Ergo, SUBTOTAL(109,...) correctly remains unchanged.
In contrast, I stumbled onto a value for C5 that changes non-hidden cells
(et al?). Ergo, SUBTOTAL(109,...) does change.

But when I change C5 to 6/1/12, I notice that the amounts in J109 and K109
do not change. They have the formulas =SUBTOTAL(109,[NetAmt]) and
=SUBTOTAL(109,[Sh Obl]).

Is that what you expect? Or are those the unchanging values that you really
want to discuss?