A
ArthurJ
A
1 10
2 #N/A
3 20
4 #N/A
5 =SumIf(A1:A4,"<>NA")
Some cells in a column of numbers evaluate to #N/A. I would like to sum the
column but ignore the #N/A entries. Is there a way to do this WITHOUT
creating a separate criteria column? I have tried various versions of the
syntax in cell A5 above without success.
Thank you,
Art
1 10
2 #N/A
3 20
4 #N/A
5 =SumIf(A1:A4,"<>NA")
Some cells in a column of numbers evaluate to #N/A. I would like to sum the
column but ignore the #N/A entries. Is there a way to do this WITHOUT
creating a separate criteria column? I have tried various versions of the
syntax in cell A5 above without success.
Thank you,
Art