I'm trying to add up all the items that started on the current day. Johnny is
the starting point person and the date & time is inserted that he started an
item is recorded next to his name, currently there should be 11 for just
today. So I figured that i'd tweak a code I got help on yesterday to do this,
here's what I have...

="Started Today - " &
SUMPRODUCT((B7:B20000="Johnny")*(C7:C20000<=9/7/2006)) & " Total"

The above code returns 8 so I also tried these variants...

="Started Today - " &
SUMPRODUCT((B7:B20000="Johnny")*(C7:C20000<9/7/2006)) & " Total"
="Started Today - " &
SUMPRODUCT((B7:B20000="Johnny")*(C7:C200009/7/2006)) & " Total"
="Started Today - " &
SUMPRODUCT((B7:B20000="Johnny")*(C7:C20000<=NOW()) ) & " Total"


There's more variants but none of them gives me the result I'm looking for.
Oh, also here's what the date colum looks like, 9/7/2006 9:01:11 AM

Thanks in Advance,
Rob