Count If equals x AND y
in [Functions]
|
Prev: Regression Formula
Next: inventory
From: Nadine on 4 May 2010 21:42 Excel 2003 Col A Col B Col C 1 No Count this cell I need to count all the cells in Col C if Col A=1 and Col B=No Thanks.
From: T. Valko on 4 May 2010 21:47 >I need to count all the cells in Col C if >Col A=1 and Col B=No Ok, what's the criteria for cells in column C? -- Biff Microsoft Excel MVP "Nadine" <Nadine(a)discussions.microsoft.com> wrote in message news:5374D99B-BCA4-485C-BDCF-E3F8C6D3D4B7(a)microsoft.com... > Excel 2003 > Col A Col B Col C > 1 No Count this cell > > I need to count all the cells in Col C if Col A=1 and Col B=No > > Thanks.
From: Ms-Exl-Learner on 4 May 2010 22:21 Try this... =SUMPRODUCT(($A1:$A65535=1)*($B1:$B65535="NO"),($C1:$C65535)) Remember to Click Yes, if this post helps! ------------------------ (Ms-Exl-Learner) ------------------------ "Nadine" <Nadine(a)discussions.microsoft.com> wrote in message news:5374D99B-BCA4-485C-BDCF-E3F8C6D3D4B7(a)microsoft.com... > Excel 2003 > Col A Col B Col C > 1 No Count this cell > > I need to count all the cells in Col C if Col A=1 and Col B=No > > Thanks.
From: Joe User on 4 May 2010 22:38 "Nadine" wrote: > Excel 2003 > Col A Col B Col C > 1 No Count this cell > I need to count all the cells in Col C if Col A=1 and Col B=No To "count" all the rows that meet that conditions in columns A and B: =sumproduct((A1:A100=1)*(B1:B100="no")) To __sum__ all the cells in column C that meet the conditions in columns A and B: =sumproduct((A1:A100=1)*(B1:B100="no"),C1:C100)
From: Steve Dunn on 5 May 2010 08:38
If you mean to count all of the non-blank cells in col C: =SUMPRODUCT(($A$1:$A$100=1)*($B$1:$B$100="No")*($C$1:$C$100<>"")) "Nadine" <Nadine(a)discussions.microsoft.com> wrote in message news:5374D99B-BCA4-485C-BDCF-E3F8C6D3D4B7(a)microsoft.com... > Excel 2003 > Col A Col B Col C > 1 No Count this cell > > I need to count all the cells in Col C if Col A=1 and Col B=No > > Thanks. |