Hi,
try

=SUMIF(C5:C7,"<#DIV/0!")

change range to fit your needs

"SueG" wrote:

I'm using Excel 2003 and I want to add a column of 20 cells. The cells have
the value of 0, 3, 5 or n/a. Can I just use AutoSum and it will ignore the
n/a but total the numbers correctly?

Thanks