sumproduct help

S

scott

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
 
D

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

scott

ill make that change.
thanks!

Dave Peterson said:
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.
Click to expand...
 
Top