Better working across workbooks
Certain functions such as COUNTIF and SUMIF give #VALUE errors if they refer to ranges in closed workbooks where as others such as MATCH work perfectly. This often leads to the need for more complex formulae using, for example, SUMPRODUCT (which does work). This needs fixing.
Kenneth Barber commented
Title's a bit vague.