Counting criteria with dates in Jan,Feb etc

M

Michael B

Hi all,

I have gone through all the previous posts and tried several different
variations but still can`t get it. Can anyone help?

I have 2 columns, one has a date in (the date closed) and the other has
either "Repudiated" or "Withdrawn" in.
I need to count the amount of entries in January that have been "Repudiated"

Any ideas please..

Many Thanks

Michael.
 
M

Mike H

Try this,

=SUMPRODUCT((MONTH(A1:A20)=1)*(B1:B20="Repudiated"))

In parctice Id use cell references for the criteria

=SUMPRODUCT((MONTH(A1:A20)=C1)*(B1:B20=D1))

Mike
 
R

Roger Govier

Hi Michael

With date in Column A and Result in B
=SUMPRODUCT(--(MONTH($A$2:$A$1000)=1),--($A$2:$A$1000<>""),
--($B$2:$B$1000="Repudiated"))
 
Top