Hi, When i type "Yes" in Column F6, the total will be computed correctly, but
when i changed it to "No", the total will be computed with the combined
values of "Yes" + "No" typed.

E.g.
"Yes" value=200
"No" value=50
(when "Yes" is typed), total is 200 ---correct
(Now, "Yes" is replaced with "No", total is 200+50 ---should display 50
instead but the problem i faced now is that total is displaying 250.

How do i configure such that when i typed "Yes", the total will be computed
normally and when i changed to "No", it will remove the memory and show the
correct value when "No" is typed. Below is what i've typed

=IF(AND((EXACT(F6,"Yes")),H6<D6),0,I6/B1)
+IF(AND((EXACT(F6,"No")),H6<D6),I6/B1,0)

=SUBTOTAL(109,Table1[Total])