Countif

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am looking for suggestions on how to use a cell reference in an expression in the countif function. Example
countif($a$1:$a$1500, ">L5") where L5 has a value of 425. If I put 425 in, it works. However, I am attempting to copy this formula to every row and the L5 becomes L6, L7 etc.
 
=COUNTIF(a1:a2,">"&L5)



DputnamEast said:
I am looking for suggestions on how to use a cell reference in an
Click to expand...
expression in the countif function. Example:
countif($a$1:$a$1500, ">L5") where L5 has a value of 425. If I put 425
Click to expand...
in, it works. However, I am attempting to copy this formula to every row
and the L5 becomes L6, L7 etc.
 
Is it possible to use two conditions(between two values) as the criteria? Example: Greater than L5 and less than K

countif(a5:a1500, ">"&L5 and "<"&K5)
 
Hi
COUNTIF only accepts one condition. You may use SUMPRODUCT:
=SUMPRODUCT((A5:A1500>L5)*(A5:A1500<K5))
 
Back
Top