Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum error
Hi, I would like to sum a range of non contiguous data eg b1,d1,f1,h1,j1 but
some of these cells contain #div/0! (because the fields they sum do not yet contain data). I have seen the answers relating to a continous range but the answers do not work when the range is non-continous because of the commas in the sum range. Any ideas would be greatly appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum error
try fixing your formulas so you don't get div/0
-- Don Guillett SalesAid Software "Michael" wrote in message ... Hi, I would like to sum a range of non contiguous data eg b1,d1,f1,h1,j1 but some of these cells contain #div/0! (because the fields they sum do not yet contain data). I have seen the answers relating to a continous range but the answers do not work when the range is non-continous because of the commas in the sum range. Any ideas would be greatly appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum error
on the source formulas, use iserror function to solve the #div/0! that you
have. eg if(iserror(a1/a2),0,(a1/a2)) hth regards from Brazil Marcelo "Michael" escreveu: Hi, I would like to sum a range of non contiguous data eg b1,d1,f1,h1,j1 but some of these cells contain #div/0! (because the fields they sum do not yet contain data). I have seen the answers relating to a continous range but the answers do not work when the range is non-continous because of the commas in the sum range. Any ideas would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom error bars not working | Charts and Charting in Excel | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Problem Opening an Excel File MSO9.DLL Error | Links and Linking in Excel | |||
error "module not found" | Excel Discussion (Misc queries) | |||
#REF error | Excel Worksheet Functions |