| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF With Conditions
Hello,
Here is my current formula: =COUNTIF(F3:F200, H5) What I would like it to do is to count the instances of H5 within that range of F3:F100 as long as the corresponding Row in Column E is equal to or less than 30. The range of Column E is obviously the same as F so E3:E200. So something like COUNTIF(F3:F200, H5, IF(E3:E200<=30)) Thank you |
| 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 2 conditions | Excel Worksheet Functions | |||
| COUNTIF with two conditions | Excel Discussion (Misc queries) | |||
| Using countif with 2 conditions | Excel Worksheet Functions | |||
| countif two conditions | Excel Discussion (Misc queries) | |||
Threaded Mode
