![]() |
#1
|
|||
|
|||
![]()
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. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
jujuwillis | Excel | 2 | 10-15-2011 11:06 AM |
![]() |
geoffm | Excel | 1 | 08-16-2011 11:31 AM |
![]() |
Aston | Word Tables | 6 | 07-15-2011 12:02 PM |
![]() |
ibrahimaa | Excel | 3 | 05-23-2011 11:23 AM |
![]() |
DeMarcos | Outlook | 1 | 06-16-2010 06:22 AM |