If you change date for "Bill" (row 4?) to 28/06/07 results is 2 as "Jhon" is
also 28/06/07 , assuming D1= 28/06/07.

OR should D1 be 29/06/07 when the result will change from 2 to 1?

See below

A B C D
Date Name Done 28/06/2007
28/06/2007 Jhon V*
28/06/2007 Mark
28/06/2007 Bill V*
29/06/2007 Tom V
30/06/2007 Phil
30/06/2007 Andi V
30/06/2007 Din V


"אלי" wrote:

Hi!

I am using the SUMPRODUCT fuction with the following table:
=SUMPRODUCT(($A$2:$A$8=$D$1)*($C$2:$C$8="V"))

A B C D
Date Name Done 28/06/2007
28/06/2007 Jhon V
28/06/2007 Mark
29/06/2007 Bill V
29/06/2007 Tom V
30/06/2007 Phil
30/06/2007 Andi V
30/06/2007 Din V

My problem is that if i am changing the date in cell A4 from 29/06/2007 to
28/06/2007 the function results is not updating (become 2 instead of 1).
Do anyone knows why??

Thanks in advance

Eli