Formulas and Display not showing correctly
On my Pages budget, i have 2 formulas (SUM) that go from A1 to A25 and one from D1 to D25
In the A column in A27, it shows the correct amount e.g. £25.74
BUT
In the D column in D27, it only shows £1, despite when i click on the box, on the bottom left hand side, it shows what the total is
Its happening in that one box on all the sheets for the rest of the year
I am confused why its working for one but not the other
Any help would be welcome
MacBook Air 13″, macOS 12.0