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