Fix the cells that have the errors:

=IF(ISERROR(your_formula),0,your_formula)

If you might want the errors:

=SUMIF(G12:G46,"<1E100")

=SUMIF(G12:G46,"<#N/A")


--
Biff
Microsoft Excel MVP


"Chris" wrote in message
...
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