COUNTIF and Cell address problem.
On sheet 1 I have columns of figures entered manually.
On sheet 2 I want to scan a specified row and return the number of entries that exceed the figure in a specified cell within that row.
=COUNTIF(Sheet1!A2:Sheet1!Y2,">Sheet1!E2") always returns 0.
IF I manually enter a figure instead of the cell address it works so I suspect my method of entering the cell address is wrong but can't find the alternative.
Help please.