Thread: sumproduct help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
scott
 
Posts: n/a
Default sumproduct help

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