Try:
=SUM(IF(NOT(ISERROR(N3:N330)),N3:N330))
as an array formula (i.e. input with ctrl-shift-enter)
=SUM(IF(NOT(ISERROR(N3:N330)),N3:N330))
as an array formula (i.e. input with ctrl-shift-enter)
Excel formula not adding up
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:
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
1 - 2 of 2 Posts
- Status
- Not open for further replies.
Tech Support Forum
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!
Full Forum Listing
Top Contributors this Month
View All
spunk.funk
143 Replies
SpywareDr
54 Replies
wolfen1086
45 Replies
Recommended Communities
