yenrod said:If I sum cells horizontally what stops the actual sum displaying in a cell to the right of the summed cells as those below and above are ok ie displaying !!!
Crackle said:is the cell formatted as a number? It's not a date or summat is it?
yenrod said:I'm displaying the sum as this: =SUM(F45:N45)
The actual sum is displaying on 'O'
I've got entries from ROW 7 - 53 and 38, 40, 43 + 45 are not displaying...!
Each Col is summed from F to N and like I said 6 to 53 rows.