=sumproduct() likes to work with numbers.

The -- converts True's and False's to 1's and 0's.

-True = -1
--True = +1


Michelle wrote:

Not to sound dumb but are the -- spaces?

"Rock" wrote:


The formula of sumproduct worked well!

Try to look at your date fomat Michelle to have exact value in between
quotation:

=sumproduct(--(A1:A30=DateValue("1/1/05")),--(B1:B30="Y"))

Regards
Rock


--
Rock
------------------------------------------------------------------------
Rock's Profile: http://www.excelforum.com/member.php...o&userid=29723
View this thread: http://www.excelforum.com/showthread...hreadid=494582



--

Dave Peterson