countif formula

T

Todd Nelson

I am having trouble coming up with a countif formula for dates. i need it to
count anything submitted with a particular month, and also then a formula to
count the next column. example

june 7 yes
june 14 no
May 21 yes
June=2
June No= 1
Does that make sense?
 
B

Bob Phillips

=SUMPRODUCT(--MONTH(A2:A20)=6))

=SUMPRODUCT(--(MONTH(A2:A20)=6),--(B2:B20="No"))
 
Top