Suming Columns While Ignoring #VALUE! Errors in the Columns

[Stryker152]

Hi,

When there is a cell with the #VALUE! error in a column that I want to sum, the sum function displays the same error. I want the function to display the sum of all the values within the column that do not have the #VALUE! error. Here is my current code for one of the columns:

Please Login or Register  to view this content.

The code was developed so that if there is a new row inserted, it will include that row in the function. Thanks for the help.

[zbor]

Why don't get rid of #VALUE! errors in the range?

Just put

Please Login or Register  to view this content.

instead of your current formula.

[Stryker152]

Hi Zbor,

I completely agree with you. I am finding it difficult to change the function that I currently have in the cell. The cell only displays the error when the Annual cell is ="N/A". Here is the code for the function:

Please Login or Register  to view this content.

If I could include the current code I have here into this cell, and have it display "N/A" instead of #VALUE!, that would be great. The reason I receive the error is because the Annual cell is equal to "N/A". That is why I decided to change the sum function for the column. Thought it might be easier. Thanks for the help.