[Millsy250777]

Hi there

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'.

Help! Thanks:smile:

 

[macropod]

Try:
=SUM(IF(NOT(ISERROR(N3:N330)),N3:N330))
as an array formula (i.e. input with ctrl-shift-enter)