Weird Excel calculation

Gers

£ -
£ -
£ -
£ -
£ -
£ -
£ -
£ -
£ -
£ -
£ -
£ -
£ -
£ 93.59
£ -
£ -
£ -
£ -
£ -
£ -
£ -
£ -
£ -
£ -
£ -
£ -
£ -
£ -
£ -
£ -
£ 18.12
£ -
£ -
£ -
£ -
£ -
£ -
£ -
£ -
£ -
£ -
£ -
£ 169.90

When doing the Sum function (via the icon) I get a wrong answer All other cells are empty - I have checked and checked and checked again. Total should be £111.71 and I can't find this phantom £58.91. Even done a search.

Can anyone give an explanation and resolution please?

saajan_12

Could be hidden rows? I'd cut the sum range in half and check the sum matches what you'd expect manually. Then repeat to narrow down where the problem area is.

Eg sum (top half of rows) = as expected? sum ( bottom half) = as expected.

If one half doesn't, then repeat halfing that section and on and on.

Gers

I deleted everything from the column and put it in again - seemed to have worked and the calculation worked correctly. Still can't work out why it was wonky in the first place.

saajan_12

My money is still on hidden rows. If you sum a range including a hidden row, it'll include that hidden value in the sum. If you highlight the lot including a hidden row and click delete, it'll also clear the hidden row, which could by why its now working.

Gers

https://forums.moneysavingexpert.com/discussion/comment/81868548#Comment_81868548

Thanks - but no, no hidden rows. Checked that. I've done the obvious thing and deleted the contents (only in those two rows) and put them back in. I hate it when a problem is 'solved' without a cause being found.

outtatune

Custom cell formatting that's making the contents appear differently from their actual values?

sausage_time

Without access to the original sheet it is very hard to say what the problem was here.