You're formula looks ok to me. Are you sure that you're not miscounting?

If you have your data filtered, maybe it's in one of the hidden rows???

Any chance you're including a row with June of a different year?

=SUMPRODUCT(--(V2:V999="CUSTOMER"),--(text(B2:B999,"yyyymm")="200606"))

Would check for June of this year.

scott wrote:

my sumproduct statement is adding 1 to the end result for some reason.
does anyone know how this might happen?

=SUMPRODUCT(--(V2:V999="CUSTOMER"),--(MONTH(B2:B999)=6))

I am trying to count how many times "customer" is selected from a drop down
list in the month of June.

Thanks,
Scott

--

Dave Peterson