ExcelBanter - countif two conditions met

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - countif two conditions met (https://www.excelbanter.com/excel-worksheet-functions/245093-countif-two-conditions-met.html)

Jerry

countif two conditions met

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

countif two conditions met

Jerry,

Use this

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

Mike

"Jerry" wrote:

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

Jacob Skaria

countif two conditions met

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
---------------
Jacob Skaria

"Jerry" wrote:

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

All times are GMT +1. The time now is 10:25 PM.