| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif Conditions - Use of conditions that vary by cell value | Excel Discussion (Misc queries) | |||
| Countif with Conditions | Excel Worksheet Functions | |||
| Countif with conditions | Excel Worksheet Functions | |||
| COUNTIF 2 conditions | Excel Worksheet Functions | |||
| COUNTIF for 2 conditions | Excel Worksheet Functions | |||
Hybrid Mode
