ExcelBanter - COUNTIF - Cell reference does not work !!

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - COUNTIF - Cell reference does not work !! (https://www.excelbanter.com/excel-programming/348928-countif-cell-reference-does-not-work.html)

[email protected]

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

jtp

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

All times are GMT +1. The time now is 12:24 PM.