sumproduct help

Giganews Newsgroups
Subject: sumproduct help
Posted by:  Scott
Date: Mon, 5 Jun 2006

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

Replies