countif

  • Thread starter Newbie Excel User
  • Start date
N

Newbie Excel User

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.
 
D

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!
 
N

Newbie Excel User

Many thanks this worked great!

Domenic said:
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!
Click to expand...
 
Top