countif two conditions met

[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

 

[Mike H]

Jerry,

Use this

=SUMPRODUCT((L2:L195<=60)*(U2:U195="Increased"))

Mike

 

[Jacob Skaria]

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