Thanks - I'll try renaming the table as a last resort.

Special-K the =COUNTIF(Table5[£],">"&Table5[@£LW]) formula generates a return but the Table5[£] reference returns all cells in that column which are over the one cell value in ">"&Table5[@£LW]). So instead of getting a 0 or 1 returns 24 that are above that figure.