| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF with two conditions
I am trying to count values of 9 or greater from column BM only if column U
equals "SHEET2!B6" This is the formula that I thought would work but I basically need to do a countif with 2 different criterias. =COUNTIF(SHEET1!U3:U2000, SHEET2!C6, IF(SHEET1!BM3:BM2000=9)) ex. SHEET1 Row 6 column U = JOHN SHEET2 C6 = JOHN SHEET1 Row 6 column BM = 9 This should bring a result of 1...meaning it counted that row as a positive response. |
| 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) | |||
| Using CountIf with 2 conditions - help! | Excel Worksheet Functions | |||
| Countif with conditions | Excel Worksheet Functions | |||
| Using countif with 2 conditions | Excel Worksheet Functions | |||
| How can I use COUNTIF to sum for two conditions? | Excel Worksheet Functions | |||
Threaded Mode
