countif two conditions met

  • Thread starter Thread starter Jerry
  • Start date Start date
J

Jerry

I am trying to count a number of rows based on the following criteria
Column L2:L195 contains numbers from 30 to 200
Column U2:U195 contains values No Change, Increased, Decrease
I need to count how many Increased under 60. Thanks in advanced
 
and if you are using 2007; you have a new function called COUNTIFS()

=COUNTIFS(L2:L195,"<=60",U2:U195,"Increased")

If this post helps click Yes
 
Back
Top