Tech Support Forum banner

Excel formula not adding up

595 Views 1 Reply 2 Participants Last post by  macropod
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:
Status
Not open for further replies.
1 - 2 of 2 Posts
Try:
=SUM(IF(NOT(ISERROR(N3:N330)),N3:N330))
as an array formula (i.e. input with ctrl-shift-enter)
1 - 2 of 2 Posts
Status
Not open for further replies.
Top