countif
 

I am trying to count the number of times data appears in a column based on
criteria from another column.

Ex: Count the number of Times "Yes" occurs for 11/01/05
A B
11/01/05 Yes
11/01/05 Yes
11/01/05 No
11/04/05 Yes
11/04/05 No

Your assistance is appreciated.

countif
 

Try...

=SUMPRODUCT(--(A1:A5="2005/11/01"+0),--(B1:B5="Yes"))

or

=SUMPRODUCT(--(A1:A5=C1),--(B1:B5="Yes"))

....where C1 contains the date of interest.

Hope this helps!

In article ,
"Newbie Excel User" <Newbie Excel
wrote:

I am trying to count the number of times data appears in a column based on
criteria from another column.

Ex: Count the number of Times "Yes" occurs for 11/01/05
A B
11/01/05 Yes
11/01/05 Yes
11/01/05 No
11/04/05 Yes
11/04/05 No

Your assistance is appreciated.

countif
 

Many thanks this worked great!

"Domenic" wrote:

Try...

=SUMPRODUCT(--(A1:A5="2005/11/01"+0),--(B1:B5="Yes"))

or

=SUMPRODUCT(--(A1:A5=C1),--(B1:B5="Yes"))

....where C1 contains the date of interest.

Hope this helps!

In article ,
"Newbie Excel User" <Newbie Excel
wrote:

I am trying to count the number of times data appears in a column based on
criteria from another column.

Ex: Count the number of Times "Yes" occurs for 11/01/05
A B
11/01/05 Yes
11/01/05 Yes
11/01/05 No
11/04/05 Yes
11/04/05 No

Your assistance is appreciated.