| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help With Sum
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help With Sum
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help With Sum
=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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
