Help With Sum

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

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...
 
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")
 
=sumif(a1:a1000,"<>#N/A")

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



"Chris" escreveu:
 
Back
Top