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:

=SUM(Z195:OFFSET(Z381,-1,0))
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.