I have a spreadsheet containing several worksheets which feed into a summary sheet. On the summary sheet, one cell is causing me problems as follows :-
cell S39 = SUM (S36:S38) where S36 = £422.78, S37 = £444.76 and S38 = blank. All those cells are formatted as Currency with two decimal places. The result is a blank cell, also formatted as Currency. I have tried setting and unsetting "set precision as displayed", but with the same answer. The galling thing is, adjacent cells give the correct result!!! It's driving me mad. Can anyone help?
I've just tried it and it seems to be ok. Is it worth inserting another row above the summary sheet (or the 'feed in' sheet), copying the original row's figures into it and then deleting the original row? Of course, this may not be possible on your particular workbook. There may be something odd lurking in cell S38.