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 ** |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF with two conditions
Use sumproduct (Somproduct):
=Sumproduct(--('Data entry'!$K$3:$K$65534="Yes");--('Data entry'!$C$3:$C$65534=B2)) Should start row be 2 or 3 ? It differs in your COUNTIF statement. HTH "Jaydubs" wrote: 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 ** |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF with two conditions
Thanks for the two corrections, the sumproduct as well as the starting row !
Great ! -- ** Fool on the hill ** "Toppers" wrote: Use sumproduct (Somproduct): =Sumproduct(--('Data entry'!$K$3:$K$65534="Yes");--('Data entry'!$C$3:$C$65534=B2)) Should start row be 2 or 3 ? It differs in your COUNTIF statement. HTH "Jaydubs" wrote: 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 ** |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF with two conditions
Reference to a solution here http://www.mrexcel.com/td0128.html -- Special-K ------------------------------------------------------------------------ Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470 View this thread: http://www.excelforum.com/showthread...hreadid=562759 |
Reply |
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 |