Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF with two conditions
Hello Excel(lent) users,
I want to use countif but with two conditions, instead of one. I tried: =COUNTIF(AND('Data entry'!$K$2:$K$65534="Yes";'Data entry'!$C$3:$C$65534=B2)) But it did not work -- ** Fool on the hill ** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i set a formulas with two conditions using countif | Excel Discussion (Misc queries) | |||
COUNTIF - multiple conditions | Excel Worksheet Functions | |||
multiple conditions in COUNTIF (Excel 2000) | Excel Discussion (Misc queries) | |||
COUNTIF for 2 conditions | Excel Worksheet Functions | |||
How can I use COUNTIF to sum for two conditions? | Excel Worksheet Functions |