Formula Help: Countif or Sumproduct

**NBVC** · 11-18-2011, 05:03 PM

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

**1979excelhelp** · 12-19-2011, 03:56 PM

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.

Originally Posted by NBVC

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

**NBVC** · 12-19-2011, 04:02 PM

That part doesn't matter as the ROWS() function takes care of the month number....

I assumed the sample data you gave above is in A2:C13... so that this formula would work if that were the case... you need to adjust the $C$2:$C$13 to suit the column of Dates you want to count.