Hi All,
So today I have been sent a file and there is a merged cell (S50 & T50) which has a value of £900 entered as a value.
When I select the cell its shows as a count of 2, a sum of £1,800 and an average of £900.
This cell was merged before the data was entered as it is part of a master...