In 2007 if you use a conditional sumproduct that refers to another
conditional sumproduct then the parent sumproduct will not calculate (even
with auto on) unless you amend a condition or F2 or save as to a new file
name.

F9 etc has no impact on the summed amount even though the child calculated
correctly. Parent sits there and does not listen.

Have tried with threads on/ off single processor /dual.