• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Cell reference instead of value in the COUNTIF?

C

cwh803

New Member
July 17, 2012


How do you enter a cell reference instead of its calculated value in the COUNTIF formula using EXCEL 2003 SP3?


In a list of numbers (C7 through C21), I want to know how many values are less than the calculated value in the “particular cell” E5.


I’m unable to figure out how to enter the “particular cell” reference E5 in the COUNTIF formula and therefore I use the value in E5, in this example “711.71”. The calculated value changes frequently, so referencing the cell would be handy.


=COUNTIF(C7:C21,">711.71")


Thanx, CWH803
 
CWH803


Firstly, Welcome to the Chandoo.org forums.


A simple modification does the trick

=COUNTIF(C7:C21,">"&E5)
 
Hi jagmohan,


Certainly. Let's say you have a dynamic range that refers to C7:C21 called "MyRange". Formula then becomes:

=COUNTIF(MyRange,">"&E5)
 
You must log in or register to reply here.
Back
Top