I have a countif formula that is looking to count data based on a criteria. The criteria is actually looking to another cell to identify the data. In one of the cells, the criteria is <=2003. The formula is not recognizing these. How do I get this to work. I have provided an attached example. Cell B3 should return 5, but is showing 0. How do I make this work?
Last edited by mjhopler; 10-18-2012 at 05:40 PM.
=countif($f$3:$f$11,"=" & a3)
similar for the next cell.
Gary's Student
It may be because <= is considered as Operator by Excel.. I have done some custom formatting and now it's working fine.. see attached:-
Book1(32).xlsx
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks