I need to sum a column where some of the cells have a value of #N/A. Is that possible? If so, how?
C Catherine Apr 24, 2007 #1 I need to sum a column where some of the cells have a value of #N/A. Is that possible? If so, how?
R Ragdyer Apr 24, 2007 #3 It's really better practice to eliminate the errors from the calculating column at the outset. However, this should do what you ask: =SUMIF(A1:A100,"<>#N/A")
It's really better practice to eliminate the errors from the calculating column at the outset. However, this should do what you ask: =SUMIF(A1:A100,"<>#N/A")
