What do you mean by the months are listed in f2 down - I need to know how many orders were placed, by the production date. I can't seem to get this formula to work explain please.
Quote Originally Posted by NBVC View Post
if data is in A2:C13

and the months are listed in F2 down...

=COUNTIFS($C$2:$C$13,">="&DATE(2011,ROWS($C$2:$C2),1),$C$2:$C$13,"<="&DATE(2011,ROWS($C$2:$C2)+1,1)-1)

copied down