2) When I change data for Susan and Ivan, the results rows change immediately. Do you have calculation set on manual or automatic?

3) R7C2 is set to 1 because it can't add anything to the previous column (which is text), and the first number in that row should always be 1. But I don't think this should cause any trouble; my theory (see above) is that something else is causing that problem.