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
Bookmarks