ill make that change.
thanks!

"Dave Peterson" wrote:

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