=sumif(a1:a1000,"<#N/A")

hth
--
pleae click yes if it was helpfull
regards from Brazil
Marcelo



"Chris" escreveu:

I am trying to total a range of cells, G12:G46 as I enter info into CA. Some
cells have error #N/A and it is stopping me from completing my project. Help
Please...
--
Chris