countif

[Guest]

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.

 

[Domenic]

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!

 

[Guest]

Many thanks this worked great!

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!