Thanks that solved the NUM message! I still can't crack the issue of why the formula is returning the same value in each of the cells.