Thanks, Logit.


The formulae used were the basic subtract and sum functions, which as I said work fine as a new table within an empty space on the spreadsheet concerned.



I'm unwilling to attach the whole spreadsheet, as there is private content within it, and as previously indicated copying the section concerned and pasting to a new workbook produces erroneous results not representing the problem.


I fully appreciate the need to have a workable sheet for you to investigate with, but I see no way to do that.

Now I'm aware of the problem I can live with it, in that if I ever change a value, I will need to manually re-enter the sum function, as I've now found that does work. It would have been useful to know the cause, but it seems I can't.


So thanks so much for your interest, but I can't see how to take this further.