sumproduct help

[Guest]

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]

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.

 

[Guest]

ill make that change.
thanks!

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.