| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Countif when column A=Num and Column B=Yes
=SUMPRODUCT(('Master Report'!$H$2:$H$2000=B1)*('Master
Report'!$K$2:$K$2000="Yes")) Both arrays must have same number of rows HTH -- AP "CMO" a écrit dans le message de ... I have been trying to count the number of occurrences when the value in the first column is 1277 and the value in the second column is "Yes". I have come up with the following formula: =SUMPRODUCT(('Master Report'!$H$2:$H$2000=B1)*('Master Report'!$K$1:$K$2000="Yes")) The result is #N/A Please can anyone help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| how can i multiply two columns | Excel Worksheet Functions | |||
| How do I Excel countif column a =? and column b = null ? | Excel Worksheet Functions | |||
| CountIf first column range = "Word" and second column range <> 0 | Excel Worksheet Functions | |||
| up to 7 functions? | Excel Worksheet Functions | |||
Hybrid Mode
