The non array formula will give erroneous results if it is used with reference to another workbook.