I am having problem totalling a column, I think because some of the cells in the column contain !VALUE as there are errors. I can't fix these errors, but I still need to total the other cells in the column which contain numerical values. Is there a way round this?
At the moment I'm doing =SUM(N3:N330) which is giving me an error.
But I'm guessing I need to add something else to that to say 'ignore the clues in this column which have errors'.