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 |
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 |
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 |
All times are GMT +1. The time now is 05:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com