|
|
#1
12-23-2011, 09:27 AM
|
|||
|
|||
COUNTIF and Cell address problem
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. 
|
|
#2
12-23-2011, 12:52 PM
|
||||
|
||||
|
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
|
|
#4
12-24-2011, 04:08 AM
|
||||
|
||||
|
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
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Vlookup, offset, match & countif
|
jujuwillis | Excel | 2 | 10-15-2011 11:06 AM |
|
using a cell content as a string with COUNTIF
|
geoffm | Excel | 1 | 08-16-2011 11:31 AM |
|
Problem with Cell Margins
|
Aston | Word Tables | 6 | 07-15-2011 12:02 PM |
|
Countif with 2 criteria
|
ibrahimaa | Excel | 3 | 05-23-2011 11:23 AM |
|
Address Book migration problem...
|
DeMarcos | Outlook | 1 | 06-16-2010 06:22 AM |
Windows 7 64bit 
Office 2010 64bit
Linear Mode
