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.

Hi

try =COUNTIF(Sheet1!A2:Sheet1!Y2,">"&Sheet1!E2)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you Pecoflyer. Just what I wanted.
ColinC

Colin
you can mark your thread solved with the thread tools dropdown. Thx

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post