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.