use =Sumif(A1:A4,"0")



On Oct 24, 7:31*pm, ArthurJ wrote:
* * * * 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