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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF with two conditions
Try it like this:
=SUMPRODUCT(--(Sheet1!U3:U2000=Sheet2!C6),--(Sheet1!BM3:BM2000=9)) -- Biff Microsoft Excel MVP "John" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF with two conditions
To get this evaluation
=COUNTIF(SHEET1!U3:U2000, SHEET2!C6, IF(SHEET1!BM3:BM2000=9)) untested, but I think you could try this: =SUMPRODUCT((SHEET1!U3:U2000=SHEET2!C6)*(SHEET1!BM 3:BM2000=9)) -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- |
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) | |||
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 |