Can't work it out!
In using the SUM formulae.
I am using rows 1 to 60 inclusive. Each item has a value of £30 - the total sum therefore should be £1800 - but it isn't - it is £1770 with the number of items certainly totalling 60!
What can be the problem? Anyone help? Or am I just thick?
The formula I am using is =SUM(D1: D60) I have spaced it because the colon and D make a smilie- how sweet!
Thanks