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

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

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