countif formula

G

Guest

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"))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

14 Day Average 4
Sum of values in row if they also correspond to a month? 1
Macro to delete rows 3
Excel Dragging countif formula with changing criteria 3
Using COUNTIF with MONTH in formula 7
Calculating With Dates 2
Summing data by month 5
Extracting the values matching to multiplr columns. 1

Top