| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
COUNTIF - Cell reference does not work !!
Hi,
If I use COUNTIF(A1:A10,"<A5"), it does not work and does not take "<A5" as valid comparision. It only takes absolute values such as "<55". What is workaround? Thanks for your time. - Kedar Agarkar |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
COUNTIF - Cell reference does not work !!
Hi Kedar, Try this =COUNTIF(A1:A10,"<" & A5) Jaso -- jt ----------------------------------------------------------------------- jtp's Profile: http://www.excelforum.com/member.php...fo&userid=2113 View this thread: http://www.excelforum.com/showthread.php?threadid=49601 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif contains a word in a reference cell | Excel Worksheet Functions | |||
| Why doesnt union reference operator work with COUNTIF? | Excel Discussion (Misc queries) | |||
| COUNTIF cell reference won't work | Excel Worksheet Functions | |||
| COUNTIF less than cell reference | Excel Discussion (Misc queries) | |||
| Countif with cell reference | Excel Worksheet Functions | |||
Hybrid Mode
