Slicemahn
02-03-2009, 10:30 AM
I have never come across this before.. I have two columns in which I perform array formulas to obtain counts. When I use the formula
=if(iserror($d3/sum($d3,$e3)),"-",$d3/sum($d3,$e3))
for cells d3=15 e3=37
I get an answer of 0?
When this formula is copied down, some cells populate correctly and others do not.
Any ideas of why this has happened?
=if(iserror($d3/sum($d3,$e3)),"-",$d3/sum($d3,$e3))
for cells d3=15 e3=37
I get an answer of 0?
When this formula is copied down, some cells populate correctly and others do not.
Any ideas of why this has happened?